Number chart with distinct count | XM Community
Skip to main content

HI,
I should insert an indicator in the dashboard that shows me how many times there are unique values in the dataset with respect to a certain embedded data.
Example I have 4 answers with an embedded data ProjectCode valued like this:

ax11122
ax11122
ax11123
ax11124

The count distinct should return 3 because there are 4 answers with 3 unique values of the embedded data ProjectCode.

How can I set a "number chart" to return this result?

Thank you

@vizz - Not sure if there is an easy way to do this, I have been trying to figure out a way myself. 

The only way that I can think of is using custom metric. To implement a solution using that, do you know the possible values that the embedded data ‘ProjectCode’ can have? If yes, is this a very big number?

Hi @Mishraji  thanks for your reply.
Unfortunately, the values are not known in advance and could be many

Were you able to solve this ? Even I have a similar requirement.

Leave a Reply


Terms & Conditions