As seen in the excel example below, I'm attempting to create a KPI in Tableau depending on the rank of key factors such as sales and profit.
KPI = If the country position (using rank formula on Tableau) is on TOP 3 = GREEN; TOP 5 = YELOW; OTHER = RED. As the second table shows
Following the logic above, I'd have to construct two calculated fields in Tableau: KPI SALES and KPI PROFIT.
The plan is to use the forms with the two calculated fields produced previously, however Tableau only supports one variable on forms, which is a problem for me, therefore I'll have to use two variables in this case.
Is there any other way to go about it?