0

How to export RAW data from Canary in Chart Trend

Forum / Questions & Answers
AxiomCanaryLabs_ExportRaw

I am attempting to export the "RAW" data from Axiom Canary Labs using a new Chart Trend and a single data point for a 24-hour period.

However, the "Edit Trends" dialog/menu will not allow me to set the "Aggregate Kind" to "None" or "Null".

How can I download the raw data without any averaging or performing any other data aggregation kind on it?

 

I've attached a PDF diagram to show an example of it.

5 replies

null
    • smason
    • 3 days ago
    • Reported - view

    Hi ,

    When you go to export the data, you will want to set the Aggregate Interval to 00:00:00. When that happens, you'll see the Row Count update to show "Raw". Here is a video demonstrating that: https://vimeo.com/1079953631?fl=pl&fe=sh

      • kris_zawada
      • 3 days ago
      • Reported - view

       thank you for this video.  This is exactly what I was looking for.

    • Real-Time Manager at CSE ICON
    • damon_vinciguerra.1
    • 3 days ago
    • Reported - view

     I'd be interested to know why you choose to export via Axiom instead of the Excel Add-In.

      • kris_zawada
      • 3 days ago
      • Reported - view

       I didn't know that a Excel Add-In existed for Axiom Canary or is it some kind of ODBC data source?  Is there a video to show how to use the Excel Add-In?

      Also, this is for energy application, so super locked down and secure.  I am only doing this to validate the data against the cloud historian I setup.
       

      • Real-Time Manager at CSE ICON
      • damon_vinciguerra.1
      • 3 days ago
      • Reported - view

       Oh! Yes, the Excel add-in is great. It's a true add-in. It adds a Ribbon with buttons and UI to allow you to search for tags and data. You can learn all about it at https://helpcenter.canarylabs.com/category/excel-add-in-v25 . It works for Cloud too.

Login to reply

Content aside

print this pagePrint this page
  • 3 days agoLast active
  • 5Replies
  • 10Views
  • 3 Following