cancel
Showing results for 
Search instead for 
Did you mean: 

Put time on y-axis (CR XI)

Former Member
0 Kudos

Post Author: yyu

CA Forum: Charts and Graphs

Hi there,

I'm trying to make a line chart to show the development of a set of items depending on distance and time. X-Axis shows the distance and Y the time. Each serie in the chart represents an item. On change of distance and item, time values should be shown.

As I was using time in seconds as NUMBER, this runs well. To convert the seconds into a more readable format such as HH:MI:SS I'll have to give up the type NUMBER, which makes it impossible (for me at the moment) to show time on Y-Axis any longer.

Does anybody have an idea? Which data type else could be used on Y besides NUMBER? Or can I use a formula to format Y?

Thanks!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: yyu

CA Forum: Charts and Graphs

Thank you krishna for the reply!

If I understood it correctly, CR builds a group based on the "on change of" fields. What can be shown is then an aggregate value. When I used seconds(NUMBER) I was able to use average, max, min etc of the seconds on the Y-Axis. But as soon as I create a formula to convert NUMBER and let his value be shown, I can only select the number of the formula values instead of the return values themselves.

Hopefully I described my problem now more clearly? And any other thoughts?

Former Member
0 Kudos

Post Author: krishna.moorthi

CA Forum: Charts and Graphs

If you are using the datfield (for getting the seconds) then it is very easy to display the mentined format.

Example : totext(CTime())