Display time in HH: mm: ss format in columns and bars charts
We need to display time fields in the format (HH: mm: ss), in the stacked column chart / stacked bar chart.
We now convert the time to decimal to generate the graph.
01:30:00 (hh: mm: ss) = 1.5 (decimal)
In bar charts, the value property (FIELDS - VALUE option) will be 1.5
By activating the display data property (FORMAT - DATA-LABELS), the displayed value is 1.5.
Instead we need to display the data 01:30:00 (hh: mm: ss) DATA-LABELS.
Possibility to indicate which field to display in DATA-LABELS.
Hour_decimal (VALUE) = Hour (HH: mm: ss) display this field
I work with some detailed call center metrics and this feature would be incredibly helpful
Rafael Schweder commented
This would be very helpful
I need this
This would be extremely helpful
Simon Wilcox commented
This would be very useful for us. Our time recording system stores in seconds, a friendly hh::mm:ss display would help comprehension of the data
Ken Loewen commented
We need this for scatter and line charts, as well as column and bar charts