I am trying to figure out the best way to display the daily average of a count by month.
Here is what the data looks like
Date(date),Location(string),UnitID(string)
2011-12-1,A,123
2011-12-1,A,456
2011-12-1,B,789
2011-12-1,B,246
2011-12-2,A,135
2011-12-2,A,123
2011-12-2,B,789
2011-12-2,B,468...
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...
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...
We have information on resource utilization in our DB that we would like to create a chart to summarize.
Basically we have Time out and time in information and would like to see what times of the day the MOST of the resources are in use. Example
TimeIn TimeOut
01:00 03:00
01:15 02:00...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.