cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pswigert Frequent Visitor
Frequent Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Line Chart- Multiple Lines Each Based on Same Value but by different time events

@pswigert

 

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.

 

12.PNG

 

Then you table will look like below:

 

13.PNG

 

Now you can just set the aggregate type into "Count (Distinct)" for ID.

 

14.PNG

 

When using chart visual, just dray the "Attribute" in Legend.

 

6.PNG

 

Regards,

Simon Hou

 

 

2 REPLIES 2
Super User
Super User

Re: Line Chart- Multiple Lines Each Based on Same Value but by different time events

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

Moderator v-sihou-msft
Moderator

Re: Line Chart- Multiple Lines Each Based on Same Value but by different time events

@pswigert

 

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.

 

12.PNG

 

Then you table will look like below:

 

13.PNG

 

Now you can just set the aggregate type into "Count (Distinct)" for ID.

 

14.PNG

 

When using chart visual, just dray the "Attribute" in Legend.

 

6.PNG

 

Regards,

Simon Hou