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
This would be very helpful to our end users.
Using time metrics is a major function of the reporting department in Fire. More than one user has asked for TIME data labels rather than the number of seconds. We really need this functionality.
Ahmad Mansoor commented
I have a column of duration values and need to report on total duration for some rows. Right now my values are being converted into floats, so this is really necessary.
For time performance reporting this is an essential element. Without it we have to present our charts in tableau and excel. This will be a game changer if you can get it into Report server. Until that point Excel ODBC linked and Tableau win hands down
Desperate for this really basic formatting of the axis
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