How to create adhoc reports with Trending

Trending

The report trending provides the ability to do analytics on any data point.  All data points are being logged and persisted according to the Data Rollup/Persistence Options configured in Aurora Admin.  By default, the platform is configured with the following intervals:  minutes, quarter hour, hour and day.  Use this chart as a guide on what data will be available for report trending. 

 Data Interval

Period of Time Data Persisted

Minutes

768 hours

32 days

¼ Hour

8784 hours

1 year

Hours

26352 hours

3 years

Days

26352 hours

3 years

 

Note:  The event related data is saved as seconds and is stored forever.

How to trend logged analog data points:

Note:  Trending is also available from the Entity Details and Event Details, go to those respective items in the User Guide on how to access the trending from those areas.

  1. Select the  reporting icon in the platform header and the platform displays the trending screen

Trending 

Trending 

  1. Enter the desired time period for the report in the From and To date fields or select the Custom list of values and select a pre-defined period time
  2. Select the settings icon to change the chart type (Line, Data Grid, Live Data), the platform defaults to Line and will display a Line Graph upon execution of the selected tags
  3. Select the settings icon to change the data interval (Minute, Qtr Hour, Hour, Day), the platform default is the best interval option based on the date range selected
  4. Select the settings icon to change the rollup (Avg, Min, Max), the platform defaults to Actual
  5. To view the tags available by System or by Location click on the View By… list of values to make the selection and the platform will display the grid per the selection
  6. To filter the grid for tag selection, select the filter icon next to the column header
  7. To sort the tag list ascending and descending double click the column header
  8. Click on the tags in the grid to include them on the report and the platform will display the selected tags in the panel on the right
  9. To create the trending chart, select the refresh icon and the platform displays the data points in the selected chart type

Trending 

  1. Use the (<--) and (-->) buttons next to the tag name in the graph legend to view the Avg, Max and Min values for each tag
  2. Select the tag name or color block in the graph legend and the platform will remove it from the graph; select it again and the platform adds it back to the graph
  3. Use the (<<), (<), (+), (-), (>) and (>>) buttons to pan to the past or future of the reported time
  4. To return to the Trending Criteria screen, select the Trending Criteria link in the header 

How to download the data points

  1. While on the chart view (line, data grid or live data) select the download icon and the platform downloads the data and displays a message to Open, Save or Cancel the request

Trending 

  1. Select Open and the platform displays the downloaded data points in csv file that can be saved as an MS Excel file

  

How to trend logged data points and compare different time periods:

  1. Select the  reporting icon in the platform header and the platform displays the trending screen

Trending 

  1. Enter the desired time period for the report in the From and To date fields or select the Custom list of values and select a pre-defined period time
  2. Select the  add comparison fields icon next to the To field and the platform displays a second row of data fields
  3. If a pre-defined time was selected when the  was selected, then the platform displays a default time to compare

Trending 

  1. To enter custom dates then start at step 2 with Custom selected for the date time fields

Trending 

  1. Select the  settings icon to change the chart type (Line, Data Grid, Live Data), the platform defaults to Line and will display a Line Graph upon execution of the selected tags
  2. Select the  settings icon to change the data interval (Minute, Qtr Hour, Hour, Day), the platform default is the best interval option based on the date range selected
  3. Select the  settings icon to change the rollup (Avg, Min, Max), the platform defaults to Actual
  4. To view the tags available by System or by Location click on the View By… list of values to make the selection and the platform will display the grid per the selection
  5. To filter the grid for tag selection, select the filter icon next to the column header
  6. To sort the tag list ascending and descending double click the column header
  7. Click on the tags in the grid to include them on the report and the platform will display the selected tags in the panel on the right
  8. To create the trending chart, select the refresh icon and the platform displays the data points in the selected chart type

Trending 

  1. Use the (<--) and (-->) buttons next to the tag name in the graph legend to view the Avg, Max and Min values for each tag
  2. Select the tag name or color block in the graph legend and the platform will remove it from the graph; select it again and the platform adds it back to the graph
  3. Use the (<<), (<), (+), (-), (>) and (>>) buttons to pan to the past or future of the reported time
  4. To return to the Trending Criteria screen, select the Trending Criteria link in the header 

How to trend logged discrete data points:

  1. Select the  reporting icon in the platform header and the platform displays the trending screen

Trending 

  1. Enter the desired time period for the report in the From and To date fields or select the Custom list of values and select a pre-defined period time

Discrete data Trending does not require a chart type selection or a data interval selection.  Discrete data is only available in a Data Grid and displays the Actual Value

  1. To view the tags available by System or by Location click on the View By… list of values to make the selection and the platform will display the grid per the selection
  2. To filter the grid for tag selection, select the  filter icon next to the column header
  3. To sort the tag list ascending and descending double click the column header
  4. Click on the tags in the grid to include them on the report and the platform will display the selected tags in the panel on the right 

Trending 

  1. To create the trending grid, select the refresh icon and the platform displays the data points in the Data Grid

Trending 

  1. To return to the Trending Criteria screen, select the Trending Criteria link in the header
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk