Skip to main content
Topics#Tableau Desktop & Web AuthoringGlenn Nyhan's Question
Glenn Nyhan (Samaritan House) asked in #Tableau Desktop & Web Authoring
Jan 3, 2024, 4:47 AM

How to Create Profitable vs. Unprofitable Formulas?

I'm studying for my Desktop Specialist Certification, and I'm using a book by Adam Mico called Tableau Desktop Specialist Certification. In the book, he has created a stacked vertical bar chart, and on this chart, he has two measures one called Profitable and the other Unprofitable (Orders) (these are used in the filter). The problem is the author does not indicate how these two figures were calculated. Does anyone know how I can create these? Thanks, in advance for any help. This will help me pass my exam.

 

Thanks,

Glenn

4 answers
  1. Saidjon Tojiboev (President's Administrative Office in Uzbekistan)
    Jan 3, 2024, 5:04 AM

    Hi @Glenn Nyhan​ 

    It would be helpful if you share a workbook to check.

    But you can create a calculation for profitable and unprofitable orders:

    IF SUM([Profit])>0 THEN "Profitable" ELSE "Unprofitable" END

    Hi @Glenn Nyhan​ It would be helpful if you share a workbook to check.Try this and let me know if it is correct

     

    Thanks

    Said

    (Please upvote all my answers and select the best one if you find them helpful)

Write an answer...
0/9000