Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    I forgot to unfilter the table, updated in the first post

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you for your input, I put the formula that you have provided but I only got Platinum and bronze values only

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

I forgot to unfilter the table, updated in the first post

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thank you Deku , it worked I adjusted the spend >0 and not is blank

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago
    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 😞