Forum Discussion
Time Duration and Time Graph Plotting
Hi Avichal ,
You can try this:
1. Duplicate column of ‘Duration’.
2. Split ‘Duration – Copy’ with ‘:’.
3. Add a custom column.
=[#"Duration - Copy.1"]*3600+[#"Duration - Copy.2"]*60+[#"Duration - Copy.3"]
4. Remove columns.
5. Create a line chart, put ‘Seconds’ in ‘Values’ and ‘Duration’ in ‘Tooltips’.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Avichal ,
You can try this:
1. Duplicate column of ‘Duration’.
2. Split ‘Duration – Copy’ with ‘:’.
3. Add a custom column.
=[#"Duration - Copy.1"]*3600+[#"Duration - Copy.2"]*60+[#"Duration - Copy.3"]
4. Remove columns.
5. Create a line chart, put ‘Seconds’ in ‘Values’ and ‘Duration’ in ‘Tooltips’.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey,
Thank you for your response. It work for me just if you can help me with one more thing :- Is there a way I can show data label with duration value ?