Setting time series filters per schedule

Effectively monitoring consumption patterns requires distinguishing between normal and abnormal usage periods. This guide will walk you through the process of configuring time series filters based on a predefined schedule. By following these steps, you can visually differentiate consumption during standard hours from that during off-peak or ground consumption periods, enhancing your ability to analyze and manage consumption data efficiently

1. Access the Static List Module. Open the Static List Module to create a new schedule.
2. Define Time Slots. Set open and closed time slots for each day of the week. These time slots will serve as the basis for your monitoring.

Here are some examples of how to filter data according to schedule in the most frequently used widgets

Steps:

1. Data Source Definition Tab:
   • Select your data source.
   • Define the grouping criteria of your choice or use dynamic steps if a date selector is defined in your dashboard.
2. Transformation:
   • Define the step size, ensuring it matches or not exceeds the planning slot. For example, if your planning slot starts at xx:45 and ends at yy:30, use a quarter-hourly time series.
   • Define the schedule filter by selecting the corresponding schedule and specifying that the period should be considered as open (open:1).
   • Choose the transformation type (sum, avg, median, etc.).
3. Counter Part Display:
   • To display the counterpart, create a second data source and repeat the steps, selecting open:0.
4. Stacked Column Chart:
   • In the Main tab, click on the “Change chart” button and select the stacked column chart to visualize the two time series.

Steps:

1. Data Source Definition Tab:
   • Select your data source.
   • Define the grouping criteria of your choice or use the period selector to inherit from the dashboard date selector.
2. Transformation:
   • Define the step size, ensuring it matches or not exceeds the planning slot.
   • Define the planning filter by selecting the related planning and specifying which period should be considered open (open:1).
   • Choose the transformation type (sum, avg, median, etc.).
3. Counter Part Display:
   • To display the counterpart, create a second data source and repeat the steps, selecting open:0.
4. Customize the Chart:
   • In the Main tab, click on the “Change chart” button and personnalize the chart by selecting the legend, colors, …

Steps:

1. Data Source Definition Tab:
   • Select your data source.
   • Define the grouping criteria of your choice or use the period selector to inherit from the dashboard date selector.
2. Transformation:
   • Define the step size, ensuring it matches or not exceeds the planning slot.
   • Define the planning filter by selecting the related planning and specifying which period should be considered open (open:1).
   • If needed, choose the transformation type (sum, avg, median, etc.).

Steps:

1. Column Definition Tab:
   • Select your data source measurement.
   • Define the grouping criteria of your choice or use the period selector to inherit from the dashboard date selector.
2. Transformation:
   • Define the step size, ensuring it matches or not exceeds the planning slot.
   • Define the planning filter by selecting the related planning and specifying which period should be considered open (open:1).
   • Choose the transformation type (sum, avg, median, etc.).
   • Define the timeframe by clicking on the clock icon and selecting a period correlated to the defined grouping criteria.

You can apply the same configuration logic to other widgets such as dynamic notes, state, or heatmap widgets to achieve similar time-based filtering and visualization.

By following these steps, you can effectively monitor and analyze consumption patterns based on your defined schedules.