Please could you provide us with more detail when you say 'colored status image'?
Is this colouring a bar chart, crosstab etc. Or do you mean an actual image?
Please provide us with the workbooks and screenshots of what you expect the outcome to look like.
Thanks for your reply Liu,
It can be any type of automatic indicator that shows something wrong or right in the chart, it can be a colored line in the chart or a signal light to alert conditions to our viewers:
In this sample the line can be interpreted as a target line, as you can see the latest bar at the right is below target. How can I create some kind of visual alert in red based on this example.
The simple option would be to great a boolean calculation. So with the below, I have created a bar chart and added in a reference line:
Then I created this boolean calculation:
The put this field onto colour in the marks card. When it fits the condition it will return the value of true, otherwise false. You can then apply a colour to true or false:
This would be the simple way. In your screenshot I can see you've got a stacked bar chart. I'm not sure if this was intentional or not, however you can do the same thing for a stacked bar chart using a secondary colour.
You'll have to create another calculated field, but you'll need to use an LOD and exclude the dimension you're using to as colour on the stacked chart:
The apply this to detail in the marks card and convert this to colour:
Now you can play around with the colours depending on whether it's true or false:
Thanks, please see the attached workbook.
Colour stacked.twbx 7.4 MB
Thanks for sharing your knowledge and the sample file, I have to get into the details to replicate this on my report but it really impressive and demonstrated the tool capability. Appreciated Liu!
1 of 1 people found this helpful
Follow this link and take a look at Alternative #3 option from the web. Blog post is from our Tableau Zen Master Ken Flerlage.
Let us know if this help.
Great resource Khan, lot of options and Gauge comparisons. Thanks a lot!
Thanks for the mention Mahfooj!
You're welcome Ken!
Glad it helped!