I'm calculating the sum of spending over a month period.
This will produce the cumalative amount, but it won't show you how you arrived at the amount in day incements. Changing the span to 1 day, doesn't produce the desired result nor does bucketing ahead of the timechart.
How do you achieve this without some major delta hack?
asked 15 Jun '12, 07:45
The answer is not pretty but it works, thanks Ayn.
answered 15 Jun '12, 11:05
you want to use the
1) simple example, running the timechart first and using streamstats to create the cumulative total on the timechart output rows.
2) similar, but with a field value instead of the count:
3) If you want to go the other way, and use
4) And streamstats also allows a 'by' term, so for example it can keep track of all of these cumulative numbers separately by some field value like 'series':
With the streamstats before the reporting command:
and last but not leasat, if you want to use the other way and use streamstats after the reporting command, you have to get a little more hands-on with stats and bin.
answered 15 Jun '12, 12:52
You could use
answered 15 Jun '12, 07:57