Loading

How to use other field for rank only for rows having same values

Udgivelsesdato: Apr 13, 2024
Opgave
How to use other field for rank only for rows having same values.  Example: Rank by Value column when values are different (1,2,3)  but rank by Number when values in Value column are same (0)
 User-added image
Trin
1. Duplicate Value column and convert to a discrete dimension - Name: Value (discrete)
2. Calculation (Count of values ):
{ FIXED [Value (discrete)]: COUNT([Value (discrete)])}
3. Rank for diff values:
if SUM([Count of values ])>1 then SUM([Value]) else RANK(SUM([Value]),'asc') end
User-added image
4. Show Number if values are same:
if SUM([Count of values ])>1 then SUM([Number]) end
User-added image
5. Rank for same values:
RANK([Number if values are same],'asc')

User-added image
6. Final Rank
if SUM([Count of values ])>1 then [Rank of same values] else [Rank for diff values] end
User-added image

 
Vidensartikelnummer

001461072

 
Indlæser
Salesforce Help | Article