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.


I am in need of a solution for this as well. Is there a way to display a distinct count of a particular embedded data field on a dashboard?


@megan.clawson , the only way I could think of was to load the survey data into an imported data project at the granularity of dimension that we would like to count. And then use it as a datasource in dashboard. But if you want count of multiple dimensions more granular than the first one, even imported data project would not work. Hope it helps.


Leave a Reply