Evandro on 13 Mar 2018 23:55:56
We need to display time fields in the format (HH: mm: ss), in the stacked column chart / stacked bar chart.
Explanation:
We now convert the time to decimal to generate the graph.
Example:
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.
Suggestion:
Possibility to indicate which field to display in DATA-LABELS.
Hour_decimal (VALUE) = Hour (HH: mm: ss) display this field
- Comments (21)
RE: Display time in HH: mm: ss format in columns and bars charts
We need this for scatter and line charts, as well as column and bar charts