How to count multi-select attribute values individually?
Does anyone know how to accomplish this?
A pivot table counts the values as stored in the database (multiple values concatenated, separated by commas), I want to count them individually.
In this example, the counts should be as follows:
Value 1 = 3
Value 2 = 2
Value 3 = 3
Page 1 / 1
I discovered I incorrectly stated the expected count for Value 3, it should be 2 not 3.
Hi @JohnBeiler61 ,
I think you could make this work by doing a cross join between CSAnswers and CSAttributeDetail.
Replace ‘TEST’ with the id of your attribute.
Because of the cross join, each of the possible choices (from CSAttributeDetail) will be compared with each of the answers (from CSAnswers). The InStr function returns the position where the text is found, or 0 if not found.
The hidden parameter makes it easier to build the formula into the Condition tab.
This will filter to return just the records that match.
This is what the results of the Generic Inquiry look like: