Forum Discussion
Getting distinct values for multiple columns
If you want a visual by date, use the same solution provided by Vvelarde and just change the visual from Table to Line and clustered column chart as below.
Best Regards,
Herbert
bhartsell i think all you need to do is use a visual such as column chart and drop useremail field to the axis area and drop bundleID field to the values area and under Values for the bundleID field click on dropdown icon and choose distinct count.
Thanks for the response!
I'm sorry if I wasn't clear, but I'm trying to find a measure (or series of measures) that allows me to put this in a visual by date. I need it to be non-repeating by BundleID for every UserEmail. So if the data set I'm using is the below, then the count for BundleID 1 is three (three different emails), the count for 2 is 1 (one different email), the count for three is 2 (two different emails), and the total count is six.
If you want a visual by date, use the same solution provided by Vvelarde and just change the visual from Table to Line and clustered column chart as below.
Best Regards,
Herbert
