Forum Discussion
sclencioco
Helper I
Helper Iline 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
sclenciocoHelper I
Helper IHi v-yulgu-msft,
I created [time diff] as MEASUREMENT. How can I make it an integer? Using Data type will do?
Thank you.
Saldie
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi sclencioco,
Not sure how you created the measure for [time diff]. But you could try this to calculate the time difference in hours/minutes/seconds.
Hour diff = DATEDIFF(MAX(Table_name[START_ON]),MAX(Table_name[END_ON]),HOUR)
Minute diff = DATEDIFF(TMAX(able_name[START_ON]),MAX(Table_name[END_ON]),MINUTE)
Second diff = DATEDIFF(MAX(Table_name[START_ON]),MAX(Table_name[END_ON]),SECOND)
Regards,
Yuliana Gu