Count if (field is like field)

[Montanarin]

hi all,

i need to show a bar chart that counts the fault code, for example field (guasti) could be '19', of course it could contains many faults like ('23,19,15'). So i need count how many times each field is presents, itself or into a more complex strings.

see my sample below

thank you

[Kushal_Chawda]

@Montanarin  do you want to do it in script or front end?

[Montanarin]

Hello Kush, i would like just to have a chart; of course if just Script solution can solve it, alright.

[Kushal_Chawda]

@Montanarin  If I understood it correctly. Do you need this?

Below is the data

Create chart with below dimension and measure

// Dimension
=ValueList($(=concat(DISTINCT guasti,',')))

//Measure
=SubStringCount(concat(DISTINCT total guasti,','),
ValueList($(=concat(DISTINCT guasti,','))))

[Kushal_Chawda · Accepted solution]

@Montanarin  script solution will go like below

Data:
LOAD guasti,
SubField(guasti,',') as guasti_all
FROM Table;

Then create a chart with Dimension guasti_all and measure count(guasti_all)

[Montanarin]

perfect... many thanks.

What about translate an "enum" to "guasti" number. i.e. 23 means "engine".