Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Unable to recount the word after it have been count in bar chart.
Labels |
---|
ITSDM; UAT |
ITSDM |
ITSDM |
ITSDM; UAT |
ITSDM; UAT |
=Pick(WildMatch(Labels, '*ITSDM*', '*UAT*'), 'ITSDM', 'UAT')
The bar chart should be
ITSDM 5
UAT 3
But the error now is
ITSDM 5
UAT 0
You can't group your records into two groups of different dimensional values at the same time.
Use Subfield() in your load script to separate your concatenated values into separate records
LOAD
Subfield(FIELD, ';') as FIELD,
....
Alternatively, use multiple expressions that filter your records instead of a dimension.
Or, you may try like:
How to i combine it with a column that is based on month?
If this requirement is something not very adhoc in nature, you should deal with it in the script. Could you share a real representative sample (like you said month column association), to help better ?
Hi,
not as a recommended solution but to show what could be done using chart expressions only without hard coded label values:
I guess the best approach to this problem would be to create a [Label] field from your [Labels] values using the 2-parameter Subfield() function like Stefan already suggested.
hope this helps
regards
Marco