on 07-20-2007 10:28 AM
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!
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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())
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.