Forum Discussion
help rank data
Hello Community, I need to categorize a visual by the below: Black / platinum is the 5% of the entity with highest spend Gold is top 20% to top 5% Silver is top 50% to top 20% Bronze is b...
I forgot to unfilter the table, updated in the first post
Deku
Super User
Super UserI forgot to unfilter the table, updated in the first post
VAR tbl = CALCULATETABLE(
SUMMARIZE(
SITE,
SITE[SRU_CODE],
SITE[SRU_DESCL_EN]
),
ALLSELECTED()
)
VAR platinum = PERCENTILEX.INC(tbl, [Spend per Nb Purchaser 12RM], 0.95)
VAR gold = PERCENTILEX.INC(tbl, [Spend per Nb Purchaser 12RM], 0.7)
VAR silver = PERCENTILEX.INC(tbl, [Spend per Nb Purchaser 12RM], 0.5)
VAR val = [Spend per Nb Purchaser 12RM]
RETURN IF(NOT(ISBLANK([Spend per Nb Purchaser 12RM])),
SWITCH(
TRUE(),
val >= platinum, "Platinum",
val >= gold, "Gold",
val >= silver, "Silver",
"Bronze"
)
)
I couldn't add the 2 columns from TIME table and the result is only platinum and gold 😞