Forum Discussion

sclencioco's avatar
sclencioco
Icon for Helper I rankHelper I
9 years ago

line graph including time difference as y axis

Hello,

 

Can you help me create a visualization(line graph) with time difference on Y-Axis and Date on X-axis. Below is my data for your reference

 

Need Help

8 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    sclencioco  what are you actually asking for, have you not tried to do this yourself?  what are you struggling with exactly?

    • sclencioco's avatar
      sclencioco
      Icon for Helper I rankHelper I
      9 years ago
      Hello, I tried it but i can not get my expected output.
  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi sclencioco,

     

    If I understand correctly, you need to show the values of column [time diff] on Y-axis, grouped on date column which is added on X-axis, right?

     

    Actually, it is not possible to achieve that. Because Y-axis only supports numeric values. If you add time value or text value, it will show Count/Count(distinct) value by default. In your scenario, you could convert your time diff to seconds or hours, then add it to Y-axis.

     

    Regards,
    Yuliana Gu

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi sclencioco,

         

        I noticed that there is a column named as [time diff] in source table, you could convert its values from HH:MM:SS to integer (seconds/hours/minutes).

         

         

        To add date values on X-axis, you could extract the date part from date/time first.

         

        Regards,
        Yuliana Gu