Table View and Device Details Export

Table View and Device Details Export

You usually monitor device performance, status, history, and interact with devices to increase optimum performance, but what if you could also view the device history as a table or line chart and export it as a CSV file instead? With the data exported in a table view, you can further dive into the data and share it with external parties.


Navigate to Device Details - Table View

You can get to the device details in a few ways:

  • Via the Site Homepage > Devices > search and select the desired Device from the device list.

  • When you search for a device by name and select it, you will be taken directly to its Device Details page.

    • The search function can be accessed by clicking on the search icon in the main navigation bar on the left.

  • Via the Site Dashboard > Areas > Select a Floor > from the floor plan graphic Click on Device Name (the same can also be achieved via system graphic)

To access the Table View, click on the Table Viewicon at the bottom of the right sidebar



Notes
You can switch between Basic, Dashboard, and Table views for the entire device details page. 


You can also customize the Table View: 

  • To view data from a specific date, select it at the top of the device details view.

  • Each column represents a point and you can add/remove by toggling the chart button on/off. 

  • Each row is a timestamp representing point values. 

  • You can adjust the column width by dragging the boundary on the right side of the column heading.

  • You can sort the table by date and time (Oldest/Newest), point values (high/low) or alphabetically.

Export Device History Data

You can export data from Device Details in a CSV format. You can export the data in a few ways depending on how you plan to use it. 

  • Click on  Export button at the top of device details page (Table or Dashboard View).



  • At “Choose Points to Export” page select:

    • The points you want to export from that device

    • The date range 

    • The alignment period:

      • Raw Data

      • 15 minutes

      • 30 minutes

      • 1 hour

      • Using these aggregate functions:

        • Average

        • Sum

        • Min

        • Max



  • On the exported file the data has the following structure:

    • Device ID and Name

    • Time

    • Selected points are individual columns

      • One column for point Value, one for point Status

  • The name of the exported file has the following format:

    • {SiteName}-{DeviceName}-{AlignmentPeriod}-{StartDate}-{EndDate} 

      • Start and End Date are the dates selected for the export.






    • Related Articles

    • Navigating to Device Details - Mobile App

      Device Details helps you to determine device performance, status, history and allows you to interact with devices in order to adjust their functioning with the aim of increasing optimum performance. There are a few ways on how you can get to device ...
    • Device Discovery

      The goal of device discovery is to identify the equipment that has been integrated into a Data Source and to bring that data into KODE OS. Follow the below steps to help you discover your devices. Navigate to a building of your choice through the ...
    • Commanding and Controlling Equipment - Mobile App

      Command and Control actions allow users to adjust setpoints and variables on equipment to influence their operations. These actions can only be performed on writable points. You can access command and control functionality by clicking on a point ...
    • Device Referencing

      Referencing is a method for KODE OS to recognize the relationship between devices. Types of references that we can use are shown below: Explanation: Device types that have symmetrical references applicable (e.g. feeds and isFeedby) can be connected ...
    • Navigating to Point Details - Mobile App

      In order to view all points from all devices in a building you can rely on Points. From the points list you can search, sort and filter points based on multiple criteria. Navigate to the Portfolio Menu of the building of your choice and select ...