Yes! It is very basic thing which tableau is not taking care of.
I Think as you have the workaround , having a calculation of
Case [Payment Src]
when 1 then "Paypal"
when 2 then "Itunes"
Would resolve the issue.....
Lets hope tableau take care of it in its next releases.
Thanks & Regards
Thanks for the reply, Srinath!
So after i do that calculation, where do I put it?
The reason why I'm confused is that I already have a calculated field in the "Marks" box that I use to color bars according to the selected parameter in [Color By]
CASE [Color By]
WHEN 'Payment Solution' THEN [Payment Src]
WHEN 'Device' THEN [Record Src]
WHEN 'Product' THEN [Package Id]
ELSE [Payment Src]
CASE Payment Solution
So given the above, where would I put this new calc you suggested?
Super thankful for your help, mate!
Looking at your situation.
It is that you have to replace [Payment Src] in you calculation "color" with the "newly calculated field".
Hope i am not confused and giving you a wrong direction . correct me if iam .
I really appreciate you taking the time to help me out!
So when I do as you suggest I get an error in the [Color By] calculation
'Expected Type Integer, Found String. Result types from CASE expressions must match'
I guess the calculation you suggested replaces the integer values of [Payment Src] with strings, and that causes a problem?
Hoping simple change in "payment src" data type from integer to string should resolve this ,
Anyway please share your workbook for the precise solution to the problem.