cumulative sum to be calculated in line graph
577478Nov 19 2007 — edited Nov 20 2007Hi,
I have to display the no of hits on stories on a per yr basis for all the months in a line graph.
But for this i want a cumulative count wherein we have the
no of hits in Jan as the first plot
no of hits in (Jan+ Feb) as 2nd plot
no of hits in (Jan+Feb+Mar) as 3rd plot
and so on...
.
I have a table called hits wherein no of hits and month('MON-YY') are the 2 fields.
No_of_hits Month
2 NOV-07
3 NOV-07
67 OCT-07
23 SEP-07
12 OCT-06
21 NOV-06
22 OCT-07
and so on...
and the ouput i want in graph should look like this
No_of_hits Month
12 OCT_06
33 NOV-06
56 SEP-07
145 OCT-07
150 NOV-07
Can you please help me out in calculating the cumulative sum.
I even want 2 y-axis to display no of stories on other scale in the same graph because no of hits and no of stories have a different scale.
Thnx in advance,
Message was edited by:
user574475