Daily Detail functions calculate daily summary values from 4 Hour, Hourly, 15 Minute, 5 Minute, and 1 Minute variable's data. In all Daily Detail functions the StartHour and StopHour set an hour range for the calculation. This allows calculations to only summarize data from certain hours in the day. The following table displays values for the start/stop hour and the corresponding times they apply to. The hours set by the start and stop hour are inclusive. Data is stored on the date of StartHour.
| 0 |
Midnight to 12:59 AM |
| 1 |
1:00 AM to 1:59 AM |
| 2 |
2:00 AM to 2:59 AM |
| 3 |
3:00 AM to 3:59 AM |
| 4 |
4:00 AM to 4:59 AM |
| 5 |
5:00 AM to 5:59 AM |
| 6 |
6:00 AM to 6:59 AM |
| 7 |
7:00 AM to 7:59 AM |
| 8 |
8:00 AM to 8:59 AM |
| 9 |
9:00 AM to 9:59 AM |
| 10 |
10:00 AM to 10:59 AM |
| 11 |
11:00 AM to 11:59 AM |
| 12 |
Noon to 12:59 PM |
| 13 |
1:00 PM to 1:59 PM |
| 14 |
2:00 PM to 2:59 PM |
| 15 |
3:00 PM to 3:59 PM |
| 16 |
4:00 PM to 4:59 PM |
| 17 |
5:00 PM to 5:59 PM |
| 18 |
6:00 PM to 6:59 PM |
| 19 |
7:00 PM to 7:59 PM |
| 20 |
8:00 PM to 8:59 PM |
| 21 |
9:00 PM to 9:59 PM |
| 22 |
10:00 PM to 10:59 PM |
| 23 |
11:00 PM to 11:59 PM |
| 24 |
Midnight to 12:59 AM |
| 25 |
1:00 AM to 1:59 AM |
| 26 |
2:00 AM to 2:59 AM |
| 27 |
3:00 AM to 3:59 AM |
| 28 |
4:00 AM to 4:59 AM |
| 29 |
5:00 AM to 5:59 AM |
| 30 |
6:00 AM to 6:59 AM |
| 31 |
7:00 AM to 7:59 AM |
| 32 |
8:00 AM to 8:59 AM |
| 33 |
9:00 AM to 9:59 AM |
| 34 |
10:00 AM to 10:59 AM |
| 35 |
11:00 AM to 11:59 AM |
| 36 |
Noon to 12:59 PM |
The following are examples of settings you might use to summarize data within a single day:
| 0 |
23 |
Summarize data for the whole day (Midnight to 11:59 PM) |
| 8 |
11 |
Summarize data from 8:00 AM through 11:59 AM |
| 12 |
12 |
Summarize data from Noon through 12:59 PM |
The following examples might be used to summarize data that includes points from two days:
| 7 |
30 |
Summarize data from 7:00 AM through 6:59 AM the next day |
| 8 |
31 |
Summarize data from 8:00 AM through 7:59 AM the next day |
| 12 |
35 |
Summarize data from Noon through 11:59 AM the next day |
DDMAX(VarNum,StartHour,StopHour)
Maximum hourly value for the date in the hour range. The hour range is set by StartHour and StopHour.
V55 = DDMAX(V8,0,23)
Calculates the maximum value for the hourly variable V8 for the entire date.
DDMIN(VarNum,StartHour,StopHour)
Minimum hourly value for the date in the hour range. The hour range is set by StartHour and StopHour.
V55 = DDMIN(V8,8,17)
Calculates the Minimum Value for the hourly variable V8 from 8:00AM through 5:5PM.
DDAVG(VarNum,StartHour,StopHour)
Average hourly value for the date in the hour range. The hour range is set by StartHour and StopHour.
V55 = DDAVG(V8,0,23)
Calculates the average value for the hourly variable V8 for the entire date. The average function totals all values found and divides by the number of values found.
DDSUM(VarNum,StartHour,StopHour)
Totals hourly values for the date in the hour range. The hour range is set by StartHour and StopHour.
V55 = DDSUM(V8,0,23)
Calculates the total value for the hourly variable V8 for the entire date.
DDCNT(VarNum,StartHour,StopHour)
Counts the number of hourly values entered for the hour range. The hour range is set by StartHour and StopHour.
V55 = DDCNT(V8,0,23)
Counts the number of values found for the hourly variable V8 for the entire date.
DDCC(VarNum,comparsion, compare expression, StartHour,StopHour)
Counts the number of daily detail values that meet the expression for the hour range. The hour range is set by StartHour and StopHour.
V55 = HCNT(V8,"<",4,0,23) Counts the number of values where V8 is less than 4 for the entire date.
V56 = DDCC(V8,">",V9,0,8) Counts the number of values where V8 is greater than V9 from midnight to 8 am.
Valid comparsions strings are: "<", ">", "<>", "=", ">=", "<="
DDLST(VarNum,StartHour,StopHour)
Finds the last value entered for the hour range. The hour range is set by StartHour and StopHour.
V55 = DDLST(V8,0,23)
Finds the last reading for the hourly variable V8 for the entire date.