Use time series properties on objects in a Workshop module and Quiver analysis

The Workshop module built in this example ([Example] Time Series Properties on Objects | Delay TSP) is built on the aviation ontology in the reference ontology, which may or may not be available on your enrollment. For more information on the relationships between those objects, see the use case overview. This example module will be a reference for you as you configure your own Workshop module using time series properties.

Selecting objects in Workshop

The Selecting an Object section of the module contains two standard Workshop widget features. A brief description of the widgets are explained below, and you can learn about general functionality in Workshop in our documentation. Follow the steps below to configure these widgets before adding time series properties to the module.

Part I: Add the Filter List widget

The Filter widget should take the Flight object set and apply filters based on the Airport properties. The filter widget should output an Airport filter that can be used in the Object Table widget.

1. In your Workshop module, choose to + Add widget, then select the Filter List widget.
2. In the right side configuration of the filter list widget, create a new variable for the Object set Input and name it "All airports". The Starting object set should should use the [Example] Airport object type.

3. Add the Airport, Complete Flight History, Airport State Name, Arriving Flight Count, and Departing Flight Count properties by selecting the + Add filter button.

4. Move down to the Filter output field, and you will see that a filter output has already been created for you. Give it a descriptive name like "airport filter"; no other configuration is required.

Part II: Add the Object Table widget

The Object Table widget will enable users to filter down on the object set and select an airport for further investigation.

1. In your Workshop module, choose to + Add widget, then select the Object Table widget.
2. In the Input data section, create a new variable and name it "filtered airports". Under Starting object set, select the Existing object set variable for all airports.

3. In the Filter... section, select Using a variable and choose the airport_filter variable we created as an output for the Filter List widget.

4. In the Column Configuration add the Title, Daily Avg Arr Delay, Daily Avg Dep Delay, and Daily count of flights columns by selecting + Add column.

5. Configure Default Sort(s) to be a property, and choose Select a property to sort by. Then, choose Arriving Flight Count.

6. Set up the output for the selected table in the Selection section of the Object Table configuration. Configure the output to run analysis on the time series properties of the selected airport.

TSPs in Workshop

The TSPs in Workshop section of the module uses the available time series transforms in Workshop. Follow the instructions below to set up the Chart XY and Metric Card widgets shown in the dashboard.

Part I: Add a Chart XY widget

1. In your Workshop module, choose to + Add widget, then select the Chart XY widget.
2. In the configuration menu to the right, choose to add a plot layer.

3. Select the layer in the menu to configure the data input as a Time series set.
4. Create a new variable that contains the daily count of flights for selected airport time series property, where the selected airport is the output variable from the Object Table widget. Be sure to give your new variable an understandable name.

5. Add another plot layer and variable for the daily dep delay for selected airport TSP.
6. Add a third plot layer for the Weekly Avg Dep delay property. This time, when setting up the time series set variable, choose to also add a transform. In the transform, select Rolling and then Average over 1 weeks as the aggregation method. Be sure to give your new variable an understandable name.

7. Ensure the axes are set up so there is an axis for each layer. You can also select where the axis units appear for each plot layer (to the left or right of the chart).

Part II. Add a metric card next to the Chart XY widget

1. Add a Metric Card widget.
2. In the configuration menu, choose to either Add Metric or use the default that is created when you first add the widget. Then, hover over the metric to open further configuration options, and choose Number as the value type.

3. Choose Select numeric value..., hover over New numeric variable, then choose Time series.
4. Select the Max weekly average departure delay variable you created when setting up the third plot layer of your Chart XY widget.
5. Select the Max aggregation type over the All time time range as the single value metric. Be sure to give your new variable an understandable name.
6. Set up numeric formatting as desired.

TSPs in Quiver

The following guidances assumes a basic knowledge of navigating Quiver. To learn more about general Quiver functionality, review our documentation.

The TSPs in Quiver section of the example Workshop module contains an embedded Quiver dashboard. This Quiver dashboard performs the same calculations as the Workshop widgets discussed above. Follow the instructions below to set up the time series chart and metric card shown in the dashboard.

Once the following steps are complete, the analysis graph and resulting dashboard should look like the examples below:

Part I: Set up time series comparison in a Quiver analysis

1. Create a new Quiver analysis with the Airport object type by selecting Objects from the top menu bar.
2. Add an object selector card with the Airport object type by selecting Search cards in the top menu bar and then searching for "object selector". Because you have already selected the Airport object type set, the object selector card will automatically be applied to the Airport objects.

3. Add an object time series property card by selecting Search cards, or hover at the bottom of the object selector card until the search bar appears. Search for "object time series property", then add it to the analysis.

4. Configure the card by selecting the cog icon next to the plot name, then select the daily average departure delay TSP from the card.

5. Using the dropdown menu in the upper right corner, select Graph to enter the graph view of your analysis.

Notice that by adding the object time series property card, a time series chart and default shared time axis card were also generated.

6. Select Search cards or hover over the object time series property card until the menu appears. Select the search button and search for "rolling aggregate" to add a rolling aggregate card to the canvas.

7. From the setting menu on the plot in the upper right of the card, choose Average with a Value of 7, indicating every 1 week. Notice that this generates a new time series chart card.

8. Select Search cards or hover over the rolling aggregate card until the menu appears, and search for "numeric aggregation" to add a time series numeric aggregation card to the canvas. Select Maximum as the aggregation type. This represents the maximum number of minutes of delay over a rolling week period for a particular airport (in this case, The Eastern Iowa Airport).

9. Navigate back to canvas mode. In the Analysis Contents section on the left, click and drag your rolling aggregate onto the time series chart you just created.

10. Select Add to new dashboard on the time series chart containing the rolling weekly aggregate and the average departure delays for the airport.

11. Repeat from step 8 to add another time series numeric aggregation representing the maximum number of minutes of delay over a rolling week period for the Eastern Iowa Airport. Add it to the new Quiver dashboard.

Part II: Set up Quiver dashboard object inputs

1. Open your dashboard using the dashboard icon in the left sidebar. You can rename the sections and charts. For example the time series chart could have the title "Average Departure delays overlayed with rolling aggregate" and the numeric aggregation chart could have the title "Maximum rolling average delay".

2. In the Inputs section of the configuration menu to the right, add the object selection variable from the Airport object set.

.

Part III (optional): Add start and end timestamps

1. Select Exit Dashboard from the top left corner of the Quiver dashboard menu, then navigate to graph mode.

2. Using the Search cards feature in the top banner, add two date/time parameter and a time range parameter card. Toggle on the Select separate start and end date parameters option, then select the date/time parameters from the dropdown menu (in our case, the parameters are called "start time" and "end time").

3. Navigate to the default shared time axis, and select Configure from the options in the top right corner.

4. Toggle the option to add a Controlled time range, then add the time range parameter. Make sure that Re-enable axis auto-zoom on updates is also toggled on.

5. Navigate back to your dashboard and add the start and end times as inputs to the dashboard. Once the dashboard is complete, publish the dashboard.

Part IV: Embed your dashboard in Workshop

1. If you created the optional start and end time inputs, you must add two Date and Time Picker widgets in Workshop.
2. Add a Quiver Dashboard widget, then select your new dashboard.
3. Select the appropriate Workshop variables as Quiver inputs.