Im trying to perform a KPI on Tableau based on the rank
of certain variables such as sales
and profit
as the excel example below
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
On Tableau, I would have to create 2 calculated field KPI_SALES
& KPI_PROFIT
following the logic above
The ideia is to use the forms
with the 2 calculated fields created above, however, the problem it that Tableau only allows to use one variable on forms
which is my problem, i will have to use 2 variables on this example
There is any other way to accomplish it?
I have solved the problem by creating fake columns such as sum(0) so each card would allowed by the chose different variables to put on marks as the picture below shows