I'm using Org Ref Codes to provide a simplified representation of values in a field - i.e. multiple different values will map to a smaller number of display values as defined by the Org Ref Code.
Value:Org Ref Code
However, when I create a report using the Org Ref Code field and an aggregated metric, the grouping is still carried out based on the original value (1-6) rather than the Org Ref Code (A-C) so I will still see multiple entries in the data table for A and B.
Whilst the aggregation in charts works as expected, is there a way to make the data table aggregate based on the output Org Ref Code?
Thanks for the post.
Unfortunately that is the intended function of Org Ref Codes. Currently there is no way to make it aggregate based on the Org Ref Code instead of the underlying values.
You have two options as work arounds:
1. Create a calculated field with CASE statements. EG: CASE WHEN 1 THEN A. CASE WHEN 2 THEN A.
2. Create a new column in your database that contains the alternative values for your numbers. EG:
I'd recommend you perform the second option.
Sorry for the disappointment but I hope this helped.