Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have sample data below:
Player | award | month |
A | gold | Jan |
A | silver | Feb |
B | silver | Jan |
B | silver | Feb |
I want to compare awards from one period to other period,
i need to check who is improved from Silver to gold
who stayed with gold with selected periods.
Here A status is improvement and B is Steady
Period should be dynamically.
Since 'gold' and 'silver' don't actually compare - they're just strings of text - I'm translating them into 1 and 2 for this. If you want to write this out with text strings you can do that, it just gets kind of ugly.
Dimension: Player
Measure:
If(FirstSortedValue(award, month)<FirstSortedValue(award,-month),'Improvement','No improvement')
expression is showing error, i used 1 for Gold and 2 for silver, still get error
i giving correct sample data again
Player | award | month |
A | silver | Jan |
A | gold | Feb |
B | silver | Jan |
B | silver | Feb |
Hi All, Could you please update on that.
This formula works fine - I tested it on my end...
Confirm that you have numeric values in both the award and month fields. As with "Gold" and "Silver", "Jan" and "Feb" are just text strings and there's no way to sort out which is bigger (other than string comparison, which is wrong because J > F)