@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.
@vizz , @Mishraji , @Neha Tank Here is how we were able to accomplish this. For our purposes, I wanted to be able to display an unduplicated count of students served in a tutoring program. Each time a teacher met with a student, the teacher logged the interaction by completing the survey, which asked for the student ID#. Using a survey workflow, the student ID# was added to a directory contact list where the student ID# was the external data reference. The directory has identity resolution rules in place to merge contacts with duplicate external data references. So, regardless of how many times a teacher met with and logged their interaction with a student, the student’s ID# would only exist one time in the directory. I also used a survey workflow to add an embedded data field to the directory: Tutoring=Yes. I published the external data reference and Tutoring field, added the directory as a second dashboard data source, and mapped them to the dashboard. I then added the number chart widget and used a filter for just the students for which Tutoring = Yes.
Hope maybe that helps!
@megan.clawson , Wow. This is interesting.
I thought of earlier in similar fashion but instead of Directory, I was thinking of imported data project. But somehow I wasn’t finding it reliable enough.
I shall give this idea a try.
Thanks.