Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data such as the below
Rating | NumericRating |
Aaa | 1 |
Aa2 | 3 |
A1 | 5 |
A2 | 6 |
A3 | 7 |
Baa1 | 8 |
Baa2 | 9 |
Baa3 | 10 |
Ba1 | 11 |
Ba2 | 12 |
Ba3 | 13 |
B1 | 14 |
B2 | 15 |
B3 | 16 |
Caa1 | 17 |
Caa2 | 18 |
Caa3 | 19 |
Ca | 20 |
C | 21 |
D | 23 |
NR | 24 |
I created a field in my application RatingDual that is Dual(Rating,NumericRating)
I want to be able to calculate an floor(avg(RatingDual)) across a population and represent that as the the textual Rating value.
Ex. Say I have a population of three rows
ID | Rating | NumericRating |
A | Aaa | 1 |
B | A2 | 6 |
C | Baa3 | 10 |
In a KPI I have the expression floor(avg(RatingDual)) which yields 5 but I want it to show "A1"
Is this possible without having to create a large pick match expression?
Thanks,
Mark
@sunny_talwar any thoughts?
Do you have a list of the ratings brought into the dashboard in addition to rating by ID? If you do, you can always use an if statement
Aggr(
If(Floor(Avg(RatingDual)) = MasterNumericRating, Rating)
, Rating)
Here MasterNumericRatingwill be from an Island table which will be made up of Rating as MasterRating and NumericRating as MasterNumericRating. You don't want this to join any of your tables in the database