This is my data, it has an event for every time a user watched a show.
I would like to create a dashboard like the following:
1 of 5 : 2
2 of 5 : 0
3 of 5 : 1
4 of 5 : 1
5 of 5 : 1
Thanks
Start by creating an LOD to calculate the number of distinct shows each user watched:
Shows Watched
// Number of distinct shows watched by each user.
{FIXED [User]: COUNTD([Show])}
You can then create 5 measures, 1 of 5, 2 of 5, etc. that checks the number of of shows watched. For example, here is 1 of 5:
1 of 5
IF [Shows Watched]=1 THEN
1
ELSE
0
END
Then you can build a view as follows:
See attached.
If that answers your question, would you be so kind as to mark my response as the "correct answer" so that we can close this thread and others can quickly find the answer? Thanks!