Y axis using unformatted data

Elastic Stack Kibana
1

I have duration data that comes in as seconds. I modified the duration field to convert it to hours as follows.

duration

This works well and I am able to see the data in hours in the Discover tab. When I try to visualize this data in a line graph, the Y-axis is appropriately scaled in hours as shown here.

y%20axis%20correct
y axis correct.PNG883×697 18.1 KB

But when I try to visualize this same data along with other data on the Y-axis as follows, the Y-axis is in seconds.

y%20axis
y axis.PNG925×698 21.3 KB

Why does it display duration in hours when it is the only data on the Y-axis but display the same data in seconds when mixed with other data? How can I have it display in hours instead?

2

Is the other data's format hours as well, or is it seconds?

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.