
1. Re: How to color two quick table calculation with the same standard
Jeevan Krishna Jun 13, 2018 1:13 PM (in response to Helen Wang)1 of 1 people found this helpfulHi Helen,
Tableau's default propert in terms of color is to use a single field (sometimes 2 but not applied to this case) to implement color for all the measures.
You can create a calculation like this.
Step 1
Find out the actual calculation behind any one of the table calculations used in your dashboard. You can just double click on the field to view that. Select All and copy to a calculated field.
Step 2:
Create a calculated field like this.
Replace the highlighted part with your copied calculation and use this in color.
This solution could have managed that if you are only showing both percentage values but you have also included a normal sales field which will always fall into greater than 60% category because 60% is nothing but 0.6. If you do not need to show the overall value and only percentages, then the above solution works because the percentages always fall between similar ranges (0  100 % most of the times)
Hope this helps.

2. Re: How to color two quick table calculation with the same standard
Helen Wang Jun 13, 2018 1:45 PM (in response to Jeevan Krishna)Thank you so much;
Do you mean: I create one color metrics and it can be used for all?
Thanks,
Helen

3. Re: How to color two quick table calculation with the same standard
Jeevan Krishna Jun 13, 2018 1:53 PM (in response to Helen Wang)1 of 1 people found this helpfulYes, this is useful in your current case because you are showing only 2 percentage fields in data. Usually this is a very big head ache in other cases.

4. Re: How to color two quick table calculation with the same standard
Helen Wang Jun 13, 2018 2:01 PM (in response to Jeevan Krishna)I appreciate your reply.
But I am wondering, if it is possible by simply editing the QoQ Color calculation I have created?
I have attached the workbook. Could you please give me some advice?
Thank you very much!!

5. Re: How to color two quick table calculation with the same standard
Jeevan Krishna Jun 13, 2018 2:12 PM (in response to Helen Wang)Your question mentioned quick table calculations, so I assumed you are using the quick table calculation features but if you are manually creating a table calc. in a calculated field, you can duplicate and edit one of the fields as the color field.
Unfortunately, I dont have proper tableau version to view your dashboard.