Basic charting question

[orionMX]

I am trying to chart the running sum of a series of data points. For example,
comapany A produces a certain number of widgets every day. I am trying to show
a chart of the running total number of widgets produced, instead of the daily
number of widgets. Am I clear? If over 5 days it produces 1,2,3,4,5 widgets on
mon,tue,wed,thu,fri... I would like chart to show data points of 1,3,6,10,15.

Any help on how to do this greatly appreciated.

[MikerRoo]

cfchart does not have this functionality built in. However, you should be
able to produce a query column with the results you want and plot that as a
chart series.

If you have an MS SQL table with columns "SalesDate", "NumWidgetsSold" you can
query like in the attached code and then feed the query result to one or more
cfchartseries tags....



SELECT
PB.SalesDate,
PB.NumWidgetsSold,
(
SELECT
SUM (NumWidgetsSold)
FROM
PrivateBooks PB2
WHERE
PB2.SalesDate <= PB.SalesDate
)
AS RunningTotal
FROM
PrivateBooks PB
ORDER BY
PB.SalesDate