Forum Discussion

bhartsell's avatar
bhartsell
Frequent Visitor
10 years ago
Solved

Getting distinct values for multiple columns

Hi    I tried looking through previous threads, but I'm not sure what exactly what I'm looking for would be called.    I have a table with several columns, but I'm concerned with two of them: Bun...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    bhartsell

     

    1. Insert a Table Visual and put in Values: BundleID and UserEmail.

    2. In UserEmail select Count(Distinct).

     

     

  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    bhartsell

     

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

bhartsell

 

Please try the solution provided by ankitpatira. In case that’s not what you expected, please post back with expected output.

 

Best Regards,

Herbert