Displaying duration in human-readable format instead of seconds on chart by axis Y?

Question

I have an advanced XML chart that displays duration in seconds on axis Y.
Sometimes, when the values are high, axis labels become difficult to interpret:

alt text

Can I set the labels in human-readable format, in appropriate value range, like this:

alt text

So far I've just set the axis type as

<param name="charting.axisY">time</param>

to have duration converted to epoch time (starting from 1970-10-01).
But it now looks rough and unprofessional since full date timestamps are included in label unit markers for the bottom and top values on the axis (not shown here).

Is there any way to configure a label convertor for the proper time scale?

Answer 1

2

In the search, where you are calculating the duration, can you add

 | fieldformat timeVariable = tostring(timeVariable,"duration")

I don't know if this will help on the chart in advanced XML, but it would make the durations look better in a table...

link

answered 22 Feb, 17:10

lguinn ♦
3.1k●2●16
accept rate: 24%

As for the tabular data, yes, I've already done so. But still looking for a solution on axis labels...

(23 Feb, 09:31) greg

I don't think there is a way to use one representation (such as epoch time) for the data values and a different (though corresponding) representation for the scale... if fieldformat doesn't do it, then I don't know what will.

(23 Feb, 11:11) lguinn ♦

Displaying duration in human-readable format instead of seconds on chart by axis Y?

Follow this question

Splunk Resources

Related questions