Number chart with distinct count | XM Community
Question

Number chart with distinct count

  • 21 April 2023
  • 3 replies
  • 164 views

Badge +3

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


3 replies

Userlevel 4
Badge +18

@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?

Badge +3

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

Userlevel 4
Badge +3

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

Leave a Reply