Hi all, I have a question here...
I have a parameter driven measure split out by a dimension (blue or yellow). I want to make an indicator when blue is > than yellow.
How can i do this? Image attached!
@Brett Grodzitsky
Hi, you would need to create two separate calcs. One for the Blue and one for the yellow.
Example of [Blue Calc]
CASE [Parameter]
WHEN "Sales" THEN SUM(IF [Hes or No Hes?]="Blue" THEN [Sales] ELSE 0 END)
WHEN "Profit" THEN SUM(IF [Hes or No Hes?]="Blue" THEN [Profit] ELSE 0 END)
WHEN "Profit Ratio" THEN
100*SUM(IF [Hes or No Hes?]="Blue" THEN [Profit] ELSE 0 END)/
SUM(IF [Hes or No Hes?]="Blue" THEN [Sales] ELSE 0 END)
END
Once you have it, you can create a table calc:
WINDOW_SUM([Blue Calc])>WINDOW_SUM([Yellow Calc])
Then you can use it in your viz.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
