|
User Details |
message
|
|
Richard
post date:
2010-02-22 15:06:11
|
My data is calculated from data in a recordset. I then want to use that calculated data results ($sumtotal) in my chart. They dynamic chart wants data in the recordset via $recordset1, "value". How can I set my value using ($sumtotal)
Thanks
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-02-23 03:10:51
|
Hello Richard.
I'm sorry but I don't quite understand the problem you have. The chart can display calculated columns like other columns. If you have a column that uses an aggregate function you just have to use that column as a series in the chart in order to plot it. So, create the recordset, select to retrieve the data from a recordset, insert the category column (usually the column that you use in 'group by') and then add the calculated columns as series.
Tell me if you still have questions.
Regards,
Andrei Rinciog
|
|
|
Richard
post date:
2010-02-23 09:54:05
|
I am doing pretty complex calculations based on user settings on the page. Adding, subtracting multiplication by percentages and division depending on user settings. The result of this data is what I want in my chart. This resulting data is not stored in a recordset but created on the fly.
I have it sort of working. I'm creating a simple chart then changing the xml data page to a php page and doing all my calculations on that page and outputting to the set labels. Its a bit of hand coding but so far its working, its just a bit cumbersome and making changes to chart from there on has to be manual coding.
I'm sure there is a simple way to do this in the program but because of time constraints I just did it in the source code.
Let me know if there is a simpler way for my future charts.
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-02-25 06:34:16
|
Hi Richard,
No, I'm afraid there isn't a simpler way to do this. If you want to modify the data outside of the query you have to do this in code.
Kind regards,
Andrei
|
|
