visualization of duration in bar chart

[Mohan_raj_c]

Hai all,

Am trying to display a duration of in stacked cloumn chart but chart visualize value as count, but i need to visualize as duration.

My data are

Name	in time	out time	Duration
Jack	8:00:01	13:30:02	5:30:01
Karthick	8:14:01	13:30:05	5:16:04

--

Thanks & Regards

Mohan Raj C

[necheverry]

 I have the same issue, and the visualization (bar chart) returns ERROR. What can I do?

[Stachu]

go to  the Query Editor and change the type of the column to Duration, it will allow aggregations then

[Anonymous]

I have the same issue, but when I try to change the column type to duration all rows return ERROR.

My data source is an Excel file. Do I need to change something in there as well?