Problems with bars chart

[jficheux]

Hi,
I'm doing a bars chart and what I need to show is on the X axis the priority of the incidents and on the Y axis the average of resolution time for that incidents. And my problems is that the format of the resolution time (Y axis) is HH:mm:ss and the chart doesn't like this format.
Does anyone know how to do it??? Please help. I'm very stuck with this issue.
Thanks in advance,

JESI

[jficheux]

Hi,
Please, can anyone help me??? Please, it's very urgent!!!
Thanks in advance,

JESI

[jar]

The question is how you want to present the Y-axis? seconds, minutes, hours ?

[jficheux]

Hi,
Thanks for your answer. I said it in my first post HH:mm:ss.
I attach an image.

Pentaho.PNG

Regards,

JESI

[Taqua]

Are your values date-objects? If so, then setting the y-axis-fmt-string of "HH:mm:ss" should work nicely. But be aware that we cannot display more than 24 hours. This is a limitation of the date-formatting system (Java) we use.

If you do not have dates yet, you will have to convert them to date first. We do not accept integers that would be interpreted as seconds, or floats interpreted as hours or any other weird thing. Convert it to a canonical object and you will be fine.

[jficheux]

Hi,
Thanks for your answer. My values are date objects. And for that reason I don't understand why it's not showing any results. I attach one picture of my settings.
Thanks in advance. I must get this working.

Report.jpg

Regards,

JESI

[jficheux]

If anybody has done a report with time objects in the Y-axis, please help. I need to do it and I don't have much time.
Please help.
Thanks in advance,

JESI