Daily Average

[Plecebo]

I have a large set of transactional data with many transactions per day on many different products what I am trying to do is create an average of the daily sum to find out how much fuel is being transacted per day (on average).

I can't seem to get BOXI to do this. I have the daily sum, but I can't get the average of a summary field

Any suggestions on things that I may want to try?

Thanks in advance for your help

 

[Plecebo]

I figured it out, no easy/neat way though.

Created variables for daytotal and added the qty up per day to get the total amount for one day.

Added variable for weekTotal, and weekCount and added each day's total amount to that weekTotal, and kept a running count of the total.

The rest was simple division... a lot to manage just to get that data.