topic Re: Showing Text Representation of Dual in a aggregation in App Development

Showing Text Representation of Dual in a aggregation

mjperreault — Sat, 16 Nov 2024 18:16:59 GMT

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

Re: Showing Text Representation of Dual in a aggregation

mjperreault — Fri, 31 Jul 2020 01:04:35 GMT

@sunny_talwar any thoughts?

Re: Showing Text Representation of Dual in a aggregation

sunny_talwar — Fri, 31 Jul 2020 11:30:31 GMT

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