Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Map Chart with a Point Layer showing different GDCs as dimension. There are already expressions in the label(Options -> General -> Labels) which display a calculated value for each GDC(dimension ) Value.
eg.
[=
gdc_name &chr(10) &
If(GetFieldSelections(Homepagev)='Data',num(sum({<Type={'Received'},month_year={"$(=monthname( max(month_year)))"},gdc_name=,[Customer Name]=>}Values)/sum({<Type={'Expected'},month_year={"$(=monthname( max(month_year)))"},gdc_name=,[Customer Name]=>}Values),'##.##%'),'')
]
The above expression shows % of Data received for each GDC eg value (100%)
-----------------------------------
I want to include an expression here which can display different values of a field "LOS" for each corresponding GDC.
GDC | LOS |
A | L1 |
A | L3 |
B | L2 |
C | L1 |
C | L2 |
C | L3 |
So displayed in the Map, i would like something like the following
A
100%
L1, L3
B
100%
L2
C
100%
L1, L2, L3
for each GDC bubble in the Map Chart correspondingly.
Please advise if this can be done or if there is a another way to do this.
You could try adding this to the end of your expression:
&chr(10) &concat(distinct LOS, ',')