<< Click to Display Table of Contents >> EQuIS 6.6 Training Exercises  >>  EQuIS Enterprise > Time Series Chart Widget	Copyright © 2018  • Modified: 11 May 2018

Overview

The Time Series Chart widget displays report output on a time series chart. The widget can display data from one or more reports and supports automatically grouping data by series, such as parameters or locations. The widget is highly configurable—titles, axes, legends, etc.

 

When a new Time Series Chart widget is created, an example spline chart is automatically created but does not contain any underlying data. The header of the chart displays a range selector that includes zoom buttons for one day, one week, one month, one year, and all the data that is included in the underlying report. The Export Menu Button can be used to download the visible chart as a .jpg/.jpeg, .png, or .svg image or download data currently displayed on the chart as a .csv file.

 

Below the header, the chart displays one or more sections. A section consists of a left axis, a right axis, and zero or more data series. Each series within the section is associated with either the left or right axis of that section. The bottom axis displays the date range.

 

If enabled in the widget properties, the Navigator will appear at the bottom of the chart. Use the Navigator to navigate the date range displayed within the chart. The Navigator shows the entire date range for the chart, with the currently visible date range selected as shown in the scroll bar. Use the bottom scroll bar to scroll through the date range.

 

If enabled in the widget properties, the Legend will appear in the top-right corner of the chart, next to the first section. Each data series will be listed with its name and color. Click the series name to show or hide that series. For series that are created by grouping report data (i.e., group series by, group sections by), the series group will only display once in the legend, even though that series may appear within multiple sections of the chart.

 

Exercise Scenario

For the Utah Location Group, we want to compare the Irrigation Water Analytes group (which contains the known GKM contaminants) to the Short-Term and Long-Term Irrigation Waters action levels. We will use a Time Series Chart widget to examine aluminum levels at all sampling locations. The concentrations of arsenic, cadmium, copper, and lead at a single sampling location will be viewed in another Time Series Chart widget.

 

 

•Add and Configure a Time Series Chart Widget

•Set Time Series Chart Widgets to Rotate through Multiple Charts

•Configure a Time Series Chart Widget to Display Multiple Data Series

 

Skills, Software and Permissions Required

•Internet Explorer 10 (or higher), Google Chrome, Mozilla Firefox or Microsoft Edge

•Editor permissions to desired facilities

•Editor permissions to desired dashboards and reports

•Viewer permissions to the groups and folders object type

•Viewer permissions to all non-administrator widgets

•Creator permissions on the dashboard, EDDs and reports object types

 

 

After a Time Series Chart widget has been added to the dashboard, data must be added from a report. The widget can then be configured to display the data as desired. In this exercise, data from an Analytical Results report will be displayed as multiple charts for different sampling locations within a single widget.

1.Navigate to any desired dashboard in EQuIS Enterprise. Select Add Widget from the Dashboard ribbon. Select the Time Series Chart widget. The widget will appear on the dashboard. Move the widget to the desired location on the dashboard.

For this exercise, return to the "Gold King Mine <your initials>” dashboard and add a Time Series Chart widget. Move the widget to the Charts section of the dashboard.

2.Select Modify Properties from the Time Series Chart widget ribbon to open the Widget Editor window. Rename the widget if desired.

For this exercise, rename the widget to "Aluminum Results over Time".

3.Select the Data tab.

4.Select the desired report from the Report drop-down. The Reports dashboard will open. Published reports for the selected EQuIS database can be viewed in either tiled or details view.

For this exercise, select the "QUARTERLY_UT_IRRIGATION_ENT<YOUR INITIALS>" report from the previous exercise. A quick way to find this report is to select the Recent folder on the Reports dashboard ribbon.

5.To change the report parameters, select Modify Properties next to the report name to open the Edit Report Parameters window.

6.Expand the appropriate nodes to select the desired parameters. If the desired parameter value is not visible from the drop-down list, go to the next page or increase the items per page being displayed. The search pane can also be used to find desired parameters. To select multiple parameters, hold the CTRL key while selecting parameters. After a parameter value has been modified, the selected value will display in green with an asterisk to the right. Default or previously selected values display in blue.

For this exercise, select the parameters in the following table. All of the parameters are the same except for the analyte (aluminum) and adding the test fraction. Go to the Results> Analyte> Group menu node and clear the existing value by selecting on the table. Then click on the Individual node and select aluminum.

 

 

7.Select the Save As button to save the parameters as a user report. A Save As window will appear, which provides the option to save to the current facility or all facilities. Change the Report Name as desired and select the Save As button to return to the Widget Editor window.

For this exercise, select the Save As button. Once the window opens, change the Report Name to "QUARTERLY_UT_IRRIGATION_AL_<YOUR INITIALS>”. Select the Save As button to close the window and return to the Widget Editor.

8.In the Date Field, select the desired date field to use for the x-axis.

For this exercise, select SAMPLE_DATE from the Date Field drop-down list.

9.In the Value Field, select the desired field to use for the y-axis.

For this exercise, select REPORT_RESULT_VALUE from the Value Field drop-down list.

10.In the Unit Field, select the desired field to use for the units.

For this exercise, select REPORT_RESULT_UNIT from the Unit Field drop-down list.

11.If desired, select Group Series By to group data from the report into separate series, based on the selected field.

For this exercise, leave the default setting of "All data in one series".

12.If desired, select Group Charts By to group data from the report into separate charts, based on the selected field.

For this exercise, select SYS_LOC_CODE from the Group Charts By drop-down list.

13.Select the desired display Type.

For this exercise, select Line from the Type drop-down list.

14.To add symbols to the chart, check the Show Markers? box.

For this exercise, check the Show Markers? box.

15.Set the Vertical Axis to the left or the right.

For this exercise, select Left.

16.Select the Add Series button and return to the Chart tab.

17.On the Chart tab, make changes to the Chart Title, Series Name, Color, Type, Min, Max, Axes, and other display options as desired. Note that by default the Legend and Navigator will be displayed.

For this exercise, configure the widget as follows:

•Change the Chart Title to "Aluminum".

•Uncheck the Show Legend box since there is only one analyte on each chart.

•Under the Series Chart/Tab column, each of the sampling locations are displayed. Each one of these will be a separate chart in the widget. Scroll up and down to view all sampling locations.

•Under the Series Name column, replace the report name with "Aluminum".

•Under the Axis Title column, replace the report name with "Concentration (ug/l)".

18.Select the Save button to view the updated widget.

19.Review the look of the charts on the widget and make modifications as desired.

For this exercise, select different sampling locations to view the various charts. Select the SJMC chart and drag the navigator scroll bar to see how the chart changes as the date range is adjusted.

 

 

 

If a Time Series Chart widget contains multiple charts, the user may click through each individual chart to view the data on the different charts. However, the widget can be configured to automatically rotate through the different charts at a specified time interval.

 

1.Select Modify Properties from the Time Series Chart widget ribbon to open the Widget Editor window.

For this exercise, select Modify Properties from the Aluminum Time Series Chart widget added in the previous objective.

2.Select the Advanced tab.

3.Change the value on “rotateTabsSeconds” from 0 to 10.

4.Select the Save button to return to the dashboard.

5.Note that the widget automatically rotates through each of the charts, remaining on each chart for 10 seconds.

6.To stop the automation, repeat the process and set the value of “rotateTabsSeconds” to 0.

 

 

When the Group Series By option is employed, multiple data series can be displayed on the same chart. This feature can be used to compare values for different series. When data series from different reports or fields are displayed on the same chart, the values can be equalized to display on the same axis.

 

Tasks

•Create and Customize a New Time Series Chart Widget for Multiple Analytes

•Clone an Existing Widget and Add Action Level to Chart

 

Create and Customize a New Time Series Chart Widget for Multiple Analytes

1.Navigate to any desired dashboard in EQuIS Enterprise. Select Add Widget from the Dashboard ribbon. Select the Time Series Chart widget. The widget will appear on the dashboard. Move the widget to the desired location on the dashboard.

For this exercise, return to the "Gold King Mine <your initials>” dashboard and add a Time Series Chart widget. Move the widget to the Charts section of the dashboard and place in the right column, placing this widget next to the Aluminum Results over Time widget.

2.Select Modify Properties from the Time Series Chart widget ribbon to open the Widget Editor window. Rename the widget if desired.

For this exercise, rename the widget to "Analytes over Time".

3.Select the Data tab.

4.Select the desired report from the Report drop-down. The Reports dashboard will open. Published reports for the selected EQuIS database can be viewed in either tiled or details view.

For this exercise, select the "QUARTERLY_UT_IRRIGATION_AL_<YOUR INITIALS>" report from the previous exercise. A quick way to find this report is to select the Recent folder on the Reports dashboard ribbon.

5.To change the report parameters, select Modify Properties next to the report name to open the Edit Report Parameters window.

6.Expand the appropriate nodes to select the desired parameters. If the desired parameter value is not visible from the drop-down list, go to the next page or increase the items per page being displayed. The search pane can also be used to find desired parameters. To select multiple parameters, hold the CTRL key while selecting parameters. After a parameter value has been modified, the selected value will display in green with an asterisk to the right. Default or previously selected values display in blue.

For this exercise, select the parameters in the following table. All of the parameters are the same from the previous report except for the location and the analyte, and therefore, will need to be changed.

7.Select the Save As button to save the parameters as a user report. A Save As window will appear, which provides the option to save to the current facility or all facilities. Change the Report Name as desired and select the Save As button to return to the Widget Editor window.

For this exercise, select the Save As button. Once the window opens, change the Report Name to "QUARTERLY_UT_IRRIGATION_MULTI_<YOUR INITIALS>”. Select the Save As button to close the window and return to the Widget Editor window.

8.In the Date Field, select the desired date field to use for the x-axis.

For this exercise, select SAMPLE_DATE from the Date Field drop-down list.

9.In the Value Field, select the desired field to use for the y-axis.

For this exercise, select REPORT_RESULT_VALUE from the Value Field drop-down list.

10.In the Unit Field, select the desired field to use for the units.

For this exercise, select REPORT_RESULT_UNIT from the Unit Field drop-down list.

11.If desired, select Group Series By to group data from the report into separate series, based on the selected field.

For this exercise, select CHEMICAL_NAME from the Group Series By drop-down list.

12.If desired, select Group Charts By to group data from the report into separate charts, based on the selected field.

For this exercise, leave the default setting of "All data in one chart".

13.Select the desired display Type.

For this exercise, select Line from the Type drop-down list.

14.To add symbols to the chart, check the Show Markers? box.

For this exercise, do not check the Show Markers? box.

15.Set the Vertical Axis to the left or the right.

For this exercise, select Left.

16.Select the Add Series button and return to the Chart tab.

17.On the Chart tab, make changes to the Chart Title, Series Name, Color, Type, Min, Max, Axes, and other display options as desired. Note that by default the Legend and Navigator will be displayed.

For this exercise, configure the widget as follows:

•Change the Chart Title to "SJMC".

•Uncheck the Show Navigator box to make more room on the chart.

•Make sure that each series is a different color.

•Under the Axis Title column, replace the report name with "Concentration (ug/l)".

18.Select the Save button to view the updated widget.

19.Review the look of the charts on the widget and make modifications as desired.

For this exercise, configure the widget as follows:

•Set the Chart Height to 400 (pixels).

•Check the Equalize Value Range box to place all four analytes on the same axis.

•Under the Axes Visible? column, leave only one analyte checked. Since all four analytes will be equalized to the same range, only one axis is needed.

20.Select the Save button to view the updated widget.

 

Clone an Existing Widget and Add Action Level to Chart

After a widget has been configured, it can be cloned (i.e., copied) rather than creating and configuring a new widget.

 

1.To clone a widget, right click on the widget ribbon and select Clone. A copy of the widget will appear in the same section of the dashboard. Move the widget to the desired location on the dashboard.

For this exercise, right click the "Analytes over Time" widget ribbon and select Clone. Move the new widget beneath the original widget if it is not already positioned there.

2.Select Modify Properties from the Time Series Chart widget ribbon to open the Widget Editor window. Rename the widget and/or modify other properties as desired.

For this exercise, rename the widget to "Arsenic". On the Chart tab, delete the series for cadmium, copper, and lead.

3.To add an action level, select the Data tab.

4.Select the desired report that contains an action level field from the Report drop-down. The Reports dashboard will open. Published reports for the selected EQuIS database can be viewed in either tiled or details view.

For this exercise, select the "QUARTERLY_UT_IRRIGATION_MULTI_<YOUR INITIALS>" report from the previous exercise. A quick way to find this report is to select the Recent folder on the Reports dashboard ribbon.

5.To change the report parameters, select Modify Properties next to the report name to open the Edit Report Parameters window.

6.Expand the appropriate nodes to select the desired parameters. If the desired parameter value is not visible from the drop-down list, go to the next page or increase the items per page being displayed. The search pane can also be used to find desired parameters. To select multiple parameters, hold the CTRL key while selecting parameters. After a parameter value has been modified, the selected value will display in green with an asterisk to the right. Default or previously selected values display in blue.

For this exercise, select the parameters in the following table. All of the parameters from the previous report are the same except for the analyte and the action level. Delete cadmium, copper, and lead. Use only the Long-Term Irrigation Waters action level, as it is more restrictive.

7.Select the Save As button to save the parameters as a user report. A Save As window will appear, which provides the option to save to the current facility or all facilities. Change the Report Name as desired and select the Save As button to return to the Widget Editor window.

For this exercise, select the Save As button. Once the window opens, change the Report Name to "QUARTERLY_UT_IRRIGATION_ARSENIC_<YOUR INITIALS>”. Select the Save As button to close the window and return to the Widget Editor window.

8.In the Date Field, select the desired date field to use for the x-axis.

For this exercise, select SAMPLE_DATE from the Date Field drop-down list.

9.In the Value Field, select the desired field to use for the y-axis.

For this exercise, select ACTION_LEVEL_VALUE from the Value Field drop-down list.

10.In the Unit Field, select the desired field to use for the units.

For this exercise, select REPORT_RESULT_UNIT from the Unit Field drop-down list.

11.If desired, select Group Series By to group data from the report into separate series, based on the selected field.

For this exercise, select ACTION_LEVEL_CODE from the Group Series By drop-down list.

12.If desired, select Group Charts By to group data from the report into separate charts, based on the selected field.

For this exercise, leave the default setting of "All data in one chart".

13.Select the desired display Type.

For this exercise, select Line from the Type drop-down list.

14.To add symbols to the chart, check the Show Markers? box.

For this exercise, do not check the Show Markers? box.

15.Set the Vertical Axis to the left or the right.

For this exercise, select Left.

16.Select the Add Series button and return to the Chart tab.

17.On the Chart tab, make changes to the Chart Title, Series Name, Color, Type, Min, Max, Axes, and other display options as desired. Note that by default the Legend and Navigator will be displayed.

For this exercise, configure the widget as follows:

•Delete the new arsenic series.

•For the new Long-Term series, set Color to Red. For the new Short-Term series, set Color to Green.(Ensure that the color for arsenic is any other color).

•Ensure that the Equalize Value Range box is checked.

•Under the Axes Visible? column, leave only arsenic checked.

18.Select the Save button to view the updated widget.

For this exercise, the value of the Short-Term Irrigation Waters action level eclipses the measured values. Return to the widget editor and remove the Short-Term Irrigation Waters data series. The good news is that all the arsenic measurements for SJMC are below the action levels.