Count For Pick and WildMatch

[#1]

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

[swuehl]

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,

....

[swuehl]

Alternatively, use multiple expressions that filter your records instead of a dimension.

[tresesco]

Or, you may try like:

[#5]

How to i combine it with a column that is based on month?

[tresesco]

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 ?

[MarcoWedel]

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