Forum Discussion

pswigert's avatar
pswigert
Regular Visitor
9 years ago
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   ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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.

     

     

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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