Create a Dashboard to View the Data

In this step, you'll use the Real Time Visualization section to build custom charts and graphs to easily monitor the virtual meter remotely.

To visualize the virtual meter's data stored at the Properties History section in AnythingDB, you will first need to create an App.

  1. Click Access Control > Apps by following these steps.
    Note: The Application Client ID and Secret ID are required for configuring the Real time Visualization module. Be sure to capture and save this information.
    Figure 1.


  2. From the left menu, click Real Time Visualization > Workbooks.
  3. Select the desired folder. By default, a root folder with your user name is already present.
  4. Click New Workbook.


  5. Name the Workbook and click Create.
  6. Create a Data Table by clicking the + icon. Data tables define the queries and source data repository definitions in order to retrieve data.
    Figure 2.


  7. Under Data Table Settings, enter a title and click the check mark to save it. Enter a description, if desired.
    Figure 3.


  8. With Data Sources highlighted, under File/URL, select Altair IoT Studio.
    Figure 4.


  9. Enter the following:
    Figure 5.


  10. Click Generate Columns.
  11. Click the Transform Settings tab and enable Time Series Analysis. Click Fetch and make sure the parameter at is set as the define time axis value. Update the barring to Auto to standardize sparse time series, which is especially common with sensor data, outputting values at defined time intervals, and potentially minimizing the number of rendered data points.
  12. Click Refresh Preview.
    The columns are populated and the requested data is displayed.
  13. Click Save.
  14. Click Back to return to the Edit Dashboard view.
  15. On the blank canvas (right half section), sketch a simple square by clicking and dragging on the blank interface.
    This enables the Visualization menu.
    Figure 6.


  16. Select the Visualization mode (from the ones available at the Combination or Time Series Visualizations) and configure it using the Visualization settings.

    For example, choose X-Axis Graph and configure it as follows by dragging and dropping the data elements to the different sections:

    1. Y:
      1. content.UD_DTYPE_KWH_ODM
      2. content.UD_DTYPE_KW_AV
    2. X
      1. Time
    Detailed information regarding Data Tables is available from the Panopticon Designer documentation and Real Time Visualization documentation.