Contents
Overview
The interval statistics dialog is a predefined display that needs to be configured as an ExplorerTask in Explorer.xml:
<explorerTask name="Interval Statistics"> <predefinedDisplay>interval statistics</predefinedDisplay> <toolbarTask>true</toolbarTask> <menubarTask>true</menubarTask> <loadAtStartup>true</loadAtStartup> </explorerTask>
This dialog will enable the user to divide the selected time series from the data viewer into intervals between a specific start and end date and calculates statistical values for those intervals. The example below shows the percentage of non missing values for each calendar month between start and end date:
A different interval can be chosen from a dropdown list, like year
:
By selecting the interval month, the intervals will be divided over the 12 months within a year. This means for example that the data from September 2014 and September 2015 is taken together in the column Sep.
:
The threshold value field can be filled and will be used when calculating the percentage of values above or below a threshold.
Multiple time series can be selected at once, this will result in multiple rows:
per time serie. This is shown below for just 1 time serie, Multiple statistics can be chosen as well for example minimum, maximum and mean:
Multiple time series and multiple statistics can be chosen, this will result in a new row for each time series for each each statistic:
The rows can be oredered by clicking on the table header, for example Location Id:
Since 2019.01 multiple extensions have been made
Extra statistics have been added:
-% Soft Min
-% Hard Min
-% Soft Max
-% Hard Max
-% Rate of Change
-% Same Reading
- Number of periods Same Reading
- The colors have been updated to fixed intervals:
- 95%-100% groen (00FF00)
- 90%-95% lichtgroen (D0F5A9)
- 80%-90% oranje (F2F5A9)
- 50%-80% lichtrood (F5DA81)
- 0% -50% rood (F79F81)
start and end date columns have been added
columns can be hidden
And export to Excel button has been added
Rows which are close to perfect / green can be hidden
