How to create a Line chart with Time duration on the y-axis?

[abhishekgupta61]

We have requirement to create line chart where Time duration should be visible on Y axis (i.e. 01:30:25)
Please help me to create the SPL for this.

Date Duration
2018-05-02 01:31:01
2018-05-01 01:25:25
2018-04-30 01:20:10

[abhishekgupta61]

max(Duration) is showing seconds values in the Y axis instead of duration (HH:MM:SS)

[woodcock]

How about some raw data and a graph/chart mockup? I do not understand.

[abhishekgupta61]

Raw data

Date Duration
2018-05-02 01:31:01
2018-05-01 01:25:25
2018-04-30 01:20:10

I want to display duration on Y axis in format (hh:mm:ss).
Currently it is coming in seconds after using below SPL code.
| chart max(Duration) over Date

[kmaron]

without more information I'm guessing but you could try something like:

| chart max(Duration) over Date