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 our virtual meter's data stored at the Raw 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 SmartWorks IoT.


    Figure 4.
  9. Enter the following:


    Figure 5.
  10. Click Generate Columns and make sure the JsonPath fields are filled as follows:
    Name JsonPath
    content.UD_DTYPE_KWH_ODM content.data.UD_DTYPE_KWH_ODM
    content.UD_DTYPE_KW_AVG content.data.UD_DTYPE_KW_AVG


    Figure 6.
  11. Click the Transform Settings tab and enable Time Series Analysis. Click Fetch and select thing.Id.


    Figure 7.
  12. Click Refresh Preview.
    The columns are populated and the reqeusted 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 8.
  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 Time Combination and configure it as follows by dragging and dropping the data elements to the different sections:

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


    Figure 9.