Forum Discussion
Pivoting table?
With the original data table, create a matrix visual using Operator name field as rows, PlatformType field as column and add this measure to the Values bucket in the matrix:
DistinctCount of PlatformType = DISTINCTCOUNT (Current Table [PlatformType])
BTW your desired output example doesn't match the original table data. If you want the number of rows for each PlatformType per user use COUNT instead of DISTINCTCOUNT
Community ChampionWith the original data table, create a matrix visual using Operator name field as rows, PlatformType field as column and add this measure to the Values bucket in the matrix:
DistinctCount of PlatformType = DISTINCTCOUNT (Current Table [PlatformType])
BTW your desired output example doesn't match the original table data. If you want the number of rows for each PlatformType per user use COUNT instead of DISTINCTCOUNT
It works great! Cheers. Yeah, you're right I cut off the last row, it should be one more with TQL.
