When designing a dashboard for SPC data, you can specify either a date period or a count for the data being retrieved. However, there is a way to limit retrievals by both a date period and a count:
Limiting counts
In some situations, you may want to apply a maximum record count to retrievals that are based on a date period.
For example, you may have a dashboard that is based on the last 90 days of data for a part that is typically produced for only a few weeks at a time. However, production for this part has increased and you now have thousands of data records for this part over the last 90 days, which makes your dashboard very slow to open. To improve the performance of this dashboard, you may decide to limit the retrieval to the last 500 records, while still ensuring that data older than 90 days is not included.
By default, SPC dashboard retrievals based on a date period are limited to the most recent 32,000 data records. You can limit these retrievals to a maximum of n records by adding dash_count=n to the Convert.db file. The number you specify for n must be greater than zero.
Limiting dates
In some situations, you may want for retrievals based on the "Last n records" to reflect only recent data.
For example, you may have a dashboard that is based on the last 500 data records for one standard. However, production for that part was suspended for several months, and you have only recently started producing this part again. So you are only interested in data from the last 30 days (up to 500 records).
By default, the date period of "All dates" is applied to SPC dashboard retrievals that are based on the "Last n records". You can limit these retrievals to a different date period by adding dash_period=p to the Convert.db file. The number you specify for p must be one of the following:
Periods that include 'today' |
|
Other periods |
||
Today |
1 |
|
Yesterday |
2 |
Last n hours ending now |
35 |
|
Last week |
8 |
One day ending now |
36 |
|
Last month |
9 |
One week ending today |
16 |
|
Last quarter |
10 |
One month ending today |
17 |
|
Last three months |
33 |
One quarter ending today |
18 |
|
Last six months |
34 |
One year ending today |
19 |
|
Last year |
11 |
Today to default low |
32 |
|
January this year |
20 |
Current week |
4 |
|
February this year |
21 |
Current month |
5 |
|
March this year |
22 |
Current quarter |
6 |
|
April this year |
23 |
Current year |
7 |
|
May this year |
24 |
All dates (the default) |
3 |
|
June this year |
25 |
|
|
|
July this year |
26 |
|
|
|
August this year |
27 |
|
|
|
September this year |
28 |
|
|
|
October this year |
29 |
|
|
|
November this year |
30 |
|
|
|
December this year |
31 |
|
|
|
First quarter |
12 |
|
|
|
Second quarter |
13 |
|
|
|
Third quarter |
14 |
|
|
|
Fourth quarter |
15 |