Forum Discussion
Solved
Line Chart- Multiple Lines Each Based on Same Value but by different time events
If my data looks like: ID EventA EventB EventC 1 5/3/2016 5/7/2016 5/9/2016 2 5/3/2016 5/2/2016 6/8/2016 3 ...
In this scenario, since you need to get the count id group on Event and Date, you need to unpivot all other columns in Query Editor.
Then you table will look like below:
Now you can just set the aggregate type into "Count (Distinct)" for ID.
When using chart visual, just dray the "Attribute" in Legend.
Regards,
Simon Hou
v-sihou-msft
Microsoft Employee
Microsoft Employee
In this scenario, since you need to get the count id group on Event and Date, you need to unpivot all other columns in Query Editor.
Then you table will look like below:
Now you can just set the aggregate type into "Count (Distinct)" for ID.
When using chart visual, just dray the "Attribute" in Legend.
Regards,
Simon Hou