Forum Discussion
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 5/3/2016 5/1/2016 9/9/2016
4 5/3/2016 7/7/2016 11/4/2016
5 6/11/2016 6/14/2016 11/13/2016
Is it possible to have a line chart where the y axis is the counts of the IDs and the axis is just the day, but three lines: counts of eventA, counts of eventB, and counts of eventC on that day?
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
2 Replies
- Baskar
Resident Rockstar
Sorry dude we cant do like this .
but we can do one thing , set hierarchy but it won't help on your case .
i thing u have to understand dude.
multiple dimension at single can't possible i think so.
sorry
v-sihou-msftMicrosoft 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
