We have a problem statement from one of our clients. We have embedded our tableau desktop on a web based platform.
There are a set of dimensions which are our filters, we are trying to customize the colors based on the dimension elements.
We have a dimension called Region and 4 values under it say East, West, North and South. And we have profit for each region.
Now the new functionality should display different colors for each region- Every region would have 2 sets of colors and the colors are assigned based upon the profit values.
Ex: Say East has 3 cities under it and the profit varies from positive to negative , we have to assign the colors based on the profit values (negative - red and positive - green)
And now say West has 3 cities under it and the profit varies from positive to negative , we have to assign the colors based on the profit values (negative - Pink and positive - aqua)
The same works for all the other regions. We have implemented this currently using a calculated field and manipulating the .tps File.
We have 2 road-blockers
1. If a new Region say South-East gets added we need to again change the calculated field and the .tps file and assign the respective colors as well.- Is there a way this can be automated?
2. This dashboard has been placed under a Web based platform, would be having a functionality to edit the colors for each region, hence the users can change the colors. The Client needs a functionality in which, once the color is changed for any of the region in the table, Tableau should pick that new color dynamically and reflect the same on the dashboard
Could you guys please help me with the above?
Attached sample workbook - 2018.1 Version of Tableau
Colors.twbx 323.9 KB