Hi all,
I have a requirement like PFA image.
I have product names and day wise sales.
I have a requirement where if I say my day sales are below a threshold for now lets take 1000$ then that day column heading should be shown with a exclamation mark image.
In current worksheet day 1 is less than 1000$ days sales then show day 1 with heading as well as exclamation mark image with it.
Hi Shashank,
I tried to implement something similar to your requirement.
In the Below Image if my sales >130000 then I am displaying a header with '!!!'.
Below are the two calculations I am using to implement this.
1) Ship Mode Sales: { Fixed [Ship Mode]: sum(Sales)}
2) Ship Mode Header: if [Ship Mode Sales]>130000 then [Ship Mode] else [Ship Mode]+' !!!' end.
Attaching workbook for you reference.
thanks Hussain the solution is perfect albeit I need to show a exclamation image with this column header not just text so that's where I am unable to add a danger indicator to a column heading in tableau
Probably you can Use UNICODE to acheive that.
Look into this article. Using symbols for calculated field