Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Plecebo

    Daily average of count grouped by month

    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...
  2. Plecebo

    Daily Average

    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...
  3. Plecebo

    Daily Average

    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...
  4. Plecebo

    Peak Usage information

    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...

Part and Inventory Search

Back
Top