The last time we talked about the User Portal, we took you through its Data Visualization tool, which dynamically renders charts from your data streams. Data Visualization recently got a small addition that brings it significant new functionality.
The new Table View gives you an entirely different look at your data. If you want more pinpoint information at a glance, or simply don’t need visualization, try clicking “View Tables” in Data Visualization:
This view reorganizes your charts into (surprise) a comprehensive table that displays every message received by SAMI, each contained in its own row. By default, the table shows the JSON payload, two timestamps (recorded by device, received by SAMI) and the corresponding device.
Think of Table View as a “behind the scenes” view of your device activity. It’s a very fast and intuitive way for you to see the data payloads being sent to SAMI. While Chart View quickly visualizes movement and trends in your data, Table View details the raw information contained in each message in an accessible way.
By clicking the pulldown menu on the upper-right of the table, you can also choose to display the device ID and message ID.
To view the full device ID or message ID, simply hover over a cell.
To the left of the table are some powerful filter options. (Note that you can click the “Filters” icon in the top-left to hide the filters, leaving more space for viewing data.)
Selecting a date on the calendar shifts the table accordingly: it will only “SHOW MESSAGES RECORDED EARLIER THAN” this date. You can also enter a specific timestamp in the boxes below the calendar.
Further below, you can select a specific connected device. Doing so will enable the last, and perhaps most powerful, filter. This allows you to search for a specific data field defined in the Manifest for the device type.
In the following unfiltered table, you can see that Simband has sent a lot of messages to SAMI with different data points (click to expand).
The filtered view only shows messages that include the “field” that you specify—in this case,
You might have realized that unlike Chart View, Table View does not display each field separately. This is just another way for you to dig through all your data, with an emphasis on timestamps and numbers instead of trends.
SAMI is a work in progress! Let us know what other functionalities you’d like to see in Data Visualization and the portals.