Using Quarter Hour Aggregation
Simphony provides consolidated sales and operational data that
is aggregated by quarter hour and by day. Those are different API
endpoints within the Business Intelligence API. The quarter hour aggregations
follow mostly the same design as the daily aggregations. Data is grouped
into quarter hours which are identified by the qrtHrNum attribute. In addition, the array also includes busHrNum and dpName which identify the business hour and
day part name as configured within Reporting and Analytics.
Quarter Hour Number (qrtHrNum)
The quarter hour number identifies the quarter hour in which the sale happened. The number maps to a specific quarter hour time range as defined in the below table. Quarter hours always start at midnight, local store time, with 1. There are a maximum of 96 quarter hours per 24-hour period.
| Quarter Hour Number (qrtHrNum) | Time Range Start (HH:MM:SS) | Time Range End (HH:MM:SS) |
|---|---|---|
|
1 |
0:00:00 |
0:14:59 |
|
2 |
0:15:00 |
0:29:59 |
|
3 |
0:30:00 |
0:44:59 |
|
4 |
0:45:00 |
0:59:59 |
|
5 |
1:00:00 |
1:14:59 |
|
6 |
1:15:00 |
1:29:59 |
|
7 |
1:30:00 |
1:44:59 |
|
8 |
1:45:00 |
1:59:59 |
|
9 |
2:00:00 |
2:14:59 |
|
10 |
2:15:00 |
2:29:59 |
|
11 |
2:30:00 |
2:44:59 |
|
12 |
2:45:00 |
2:59:59 |
|
13 |
3:00:00 |
3:14:59 |
|
14 |
3:15:00 |
3:29:59 |
|
15 |
3:30:00 |
3:44:59 |
|
16 |
3:45:00 |
3:59:59 |
|
17 |
4:00:00 |
4:14:59 |
|
18 |
4:15:00 |
4:29:59 |
|
19 |
4:30:00 |
4:44:59 |
|
20 |
4:45:00 |
4:59:59 |
|
21 |
5:00:00 |
5:14:59 |
|
22 |
5:15:00 |
5:29:59 |
|
23 |
5:30:00 |
5:44:59 |
|
24 |
5:45:00 |
5:59:59 |
|
25 |
6:00:00 |
6:14:59 |
|
26 |
6:15:00 |
6:29:59 |
|
27 |
6:30:00 |
6:44:59 |
|
28 |
6:45:00 |
6:59:59 |
|
29 |
7:00:00 |
7:14:59 |
|
30 |
7:15:00 |
7:29:59 |
|
31 |
7:30:00 |
7:44:59 |
|
32 |
7:45:00 |
7:59:59 |
|
33 |
8:00:00 |
8:14:59 |
|
34 |
8:15:00 |
8:29:59 |
|
35 |
8:30:00 |
8:44:59 |
|
36 |
8:45:00 |
8:59:59 |
|
37 |
9:00:00 |
9:14:59 |
|
38 |
9:15:00 |
9:29:59 |
|
39 |
9:30:00 |
9:44:59 |
|
40 |
9:45:00 |
9:59:59 |
|
41 |
10:00:00 |
10:14:59 |
|
42 |
10:15:00 |
10:29:59 |
|
43 |
10:30:00 |
10:44:59 |
|
44 |
10:45:00 |
10:59:59 |
|
45 |
11:00:00 |
11:14:59 |
|
46 |
11:15:00 |
11:29:59 |
|
47 |
11:30:00 |
11:44:59 |
|
48 |
11:45:00 |
11:59:59 |
|
49 |
12:00:00 |
12:14:59 |
|
50 |
12:15:00 |
12:29:59 |
|
51 |
12:30:00 |
12:44:59 |
|
52 |
12:45:00 |
12:59:59 |
|
53 |
13:00:00 |
13:14:59 |
|
54 |
13:15:00 |
13:29:59 |
|
55 |
13:30:00 |
13:44:59 |
|
56 |
13:45:00 |
13:59:59 |
|
57 |
14:00:00 |
14:14:59 |
|
58 |
14:15:00 |
14:29:59 |
|
59 |
14:30:00 |
14:44:59 |
|
60 |
14:45:00 |
14:59:59 |
|
61 |
15:00:00 |
15:14:59 |
|
62 |
15:15:00 |
15:29:59 |
|
63 |
15:30:00 |
15:44:59 |
|
64 |
15:45:00 |
15:59:59 |
|
65 |
16:00:00 |
16:14:59 |
|
66 |
16:15:00 |
16:29:59 |
|
67 |
16:30:00 |
16:44:59 |
|
68 |
16:45:00 |
16:59:59 |
|
69 |
17:00:00 |
17:14:59 |
|
70 |
17:15:00 |
17:29:59 |
|
71 |
17:30:00 |
17:44:59 |
|
72 |
17:45:00 |
17:59:59 |
|
73 |
18:00:00 |
18:14:59 |
|
74 |
18:15:00 |
18:29:59 |
|
75 |
18:30:00 |
18:44:59 |
|
76 |
18:45:00 |
18:59:59 |
|
77 |
19:00:00 |
19:14:59 |
|
78 |
19:15:00 |
19:29:59 |
|
79 |
19:30:00 |
19:44:59 |
|
80 |
19:45:00 |
19:59:59 |
|
81 |
20:00:00 |
20:14:59 |
|
82 |
20:15:00 |
20:29:59 |
|
83 |
20:30:00 |
20:44:59 |
|
84 |
20:45:00 |
20:59:59 |
|
85 |
21:00:00 |
21:14:59 |
|
86 |
21:15:00 |
21:29:59 |
|
87 |
21:30:00 |
21:44:59 |
|
88 |
21:45:00 |
21:59:59 |
|
89 |
22:00:00 |
22:14:59 |
|
90 |
22:15:00 |
22:29:59 |
|
91 |
22:30:00 |
22:44:59 |
|
92 |
22:45:00 |
22:59:59 |
|
93 |
23:00:00 |
23:14:59 |
|
94 |
23:15:00 |
23:29:59 |
|
95 |
23:30:00 |
23:44:59 |
|
96 |
23:45:00 |
23:59:59 |
Business Hour (busHrNum)
The business hour defines the hours of the business date, starting at midnight of the business date.
If the start of day happened to occur at midnight, the first business hour value is 0, then 1:00 a.m. is 1, and so on. If the business date goes past 24 hours, after midnight, then the business hour value is 25 for the time range midnight to 1:00 a.m., then 26 for 1:00 a.m. to 2:00 a.m.
If the business date's start of day is at 5:00 a.m., then the first business hour value is 5.
The maximum value for business hour is 240 if the business date doesn’t change for multiple days.
Day Part Name (dpName)
The day part name is returned according to the configuration of day parts within Reporting and Analytics. Day parts are configured for the whole enterprise and also map to the quarter hour start and end times. See Day Parts in the Reporting and Analytics User Guide for details on day parts and their configuration.