Skip to main content

Charting Your Data

  • Updated
The Turntide Charting Tool allows you to look at historical data from one or multiple pieces of equipment. Your data is saved forever on the cloud, so it's always accessible through this powerful and intuitive tool on the Turntide app.
 

To Start Charting

  1. From the landing page, click Charting located on the toolbar on the left-hand side of the page.
    Screen_Shot_2022-02-25_at_10.50.58_AM.png
  2. Click the Viewer tab to open the charting environment.
    1. Note: Overview is your personal library of all previously saved charts that you've created.
      Screen_Shot_2022-02-25_at_10.55.01_AM.png
  3. To create a chart, select the following information:
    1. Site - Select the site(s) containing the equipment you intend to chart.
    2. Equipment - Select one or multiple pieces of equipment.
    3. Points - Select which data from the equipment you wish to chart (ex. Room Temperature).
    4. Range - Select how far back you wish to plot this data (ex. Today, Last Week)
      Screen_Shot_2022-02-25_at_11.18.51_AM.png
  4. Click Save Chart to add it to your Overview page.
    Screen_Shot_2022-02-25_at_11.20.15_AM.png

Just like that, you've created a visual representation of your data! If this is a chart you plan to revisit in the future.

Additional Features

  • Timestamp - Hover over any portion of the data to see the numerical value at that given time.
  • Zoom - Drag over your desired section of data in the secondary chart located below the main display. This will alter the main display to focus in on just that section.
  • Secondary Axis - Add a second axis to your chart when plotting multiple points that use different units. Click Show Legend on the right side of the page and select Y2 Axis on the desired point.
  • List - Change your selected data range to list form by clicking the View List button.
  • Export Data - Use the Export Data button to convert your selected data into a .csv file.

Advanced Settings

The rollup field contains aggregate functions that can be applied to values during the rollup operation. Turntide supports the following functions:

  • Max - Largest point value

  • Min - Smallest point value

  • Mean - Mean of all point values rolled up

  • Median - Median of all point values rolled up

  • Mode - Most common point value

  • Standard Deviation - a quantity calculated to indicate the extent of deviation for a group as a whole.

  • Sum - The total of adding up all rollup values

  • Variance - The variability from the average or mean

  • default - Same as mean

  • First - The first item/oldest item for the minute/ hour / day / week / month etc (defined by Rollup Frequency)

  • Last - The last or latest item for the minute/ hour / day / week / month etc

  • Count - Count of number of items for the minute/ hour / day / week / month etc

  • None - No rollup is applied

Rollup Frequency is the time period at which this rollup is calculated, Turntide supports the following rollup frequencies:

  • Minutes

  • Hourly

  • Daily

  • Weekly

  • Monthly

  • Yearly

Related articles