Forum Discussion
Line Chart to display average time (hh mm ss)
I am trying to create a line chart to show average waiting times (example data below - time values are displayed in hh mm ss format).
| Date | Arrival | Talk | Wait | Month |
| 02/10/2017 | 07:33:05 | 00:05:41 | 00:00:08 | Oct |
| 02/10/2017 | 07:43:26 | 00:19:23 | 00:00:06 | Oct |
| 02/10/2017 | 07:50:37 | 00:00:37 | 00:00:10 | Oct |
| 02/10/2017 | 07:51:56 | 00:02:34 | 00:00:10 | Oct |
| 02/10/2017 | 08:02:56 | 00:09:36 | 00:00:08 | Oct |
| 02/10/2017 | 08:10:05 | 00:01:08 | 00:00:06 | Oct |
| 17/11/2017 | 14:14:31 | 00:01:42 | 00:08:42 | Nov |
| 17/11/2017 | 14:20:40 | 00:09:23 | 00:04:16 | Nov |
| 17/11/2017 | 14:23:03 | 00:05:21 | 00:02:08 | Nov |
| 17/11/2017 | 14:45:23 | 00:05:55 | 00:04:45 | Nov |
| 17/11/2017 | 14:53:07 | 00:07:05 | 00:00:28 | Nov |
| 17/11/2017 | 14:54:57 | 00:03:48 | 00:02:26 | Nov |
| 17/11/2017 | 14:58:19 | 00:10:58 | 00:02:27 | Nov |
| 17/11/2017 | 15:05:08 | 00:05:50 | 00:00:05 | Nov |
| 17/11/2017 | 15:14:10 | 00:02:03 | 00:03:37 | Nov |
| 17/11/2017 | 15:19:25 | 00:04:14 | 00:01:35 | Nov |
The problem i am facing is the Y axis is not formatting to a time value and is showing Y axis values of 0.0008 and 0.0009
What i need is a line graph that has the Y axis showing time intervals in time format (hh mm ss), the X axis showing the month and a line to show average wait times for the month.
Thanks.
1 Reply
v-yulgu-msftMicrosoft Employee
Hi nikhil2992,
In a chart visual, Y-axis only supports numeric fields. Any other data type added to it will be aggregated with "Count" by default. In your scenario, it is not possible to display time values in "hh:mm:ss" format on -Y-axis. As a workaround, you could convert the time format "hh:mm:ss" to hours or minutes or seconds in numeric format.
Regards,
Yuliana Gu