Create a Dashboard Using Data from AnythingDB

With this solution you can see the Data how you want, where you want, and fast enough to act quickly.

This tool is powered by Altair Panopticon and supports a wide range of information visualizations, including our well-known Treemaps, Heat Maps, Scatter Plots, Horizon Graphs, and a wide range of other great visualizations designed for fast comprehension and easy interpretation of static, time series, real-time streaming, and historic data sets.

Important: To visualize data stored at the Raw History section in AnythingDB, or the data stored in a Category, you will first need to create an app. If not, skip Step 1 and begin at Step 2.

Click Access Control > Apps and create a new App by following these steps.

Note: The Application Client ID and Secret ID is required in configuring the New Workbook in Real time Visualization module. Be sure to capture and save this information.
From the left menu, click Real Time Visualization > Workbooks.
Select the desired folder. By default, a root folder with your username is already present.
Click New Workbook.
Name the Workbook and click Create.
Create a Data Table by clicking the + icon.
Data tables define the queries and source data repository definitions, in order to retrieve data.

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

Figure 2. Data Table tab settings
With Data Sources highlighted, under File/URL, select SmartWorks IoT.

Figure 3. Data Table tab settings
Enter the following:
- Client ID: from the App created in Step 1
- Client Secret: from the App created in Step 1
- Grant Type: type of App created in Step 1. Here we use client_credentials.
- Scope: from the App created. Choose Thing to retrieve the Thing status of a Category, and Data to retrieve the data stored at the Raw History section.
- URL: to make the request.
  - If you want to retrieve the Things status of a Category: https://api.swx.altairone.com/spaces/YourSpaceID/categories/YourCategoryName/things-status
  - If you want to retrieve the data stored at the raw history section for different things: https://api.swx.altairone.com/spaces/YourSpaceID/data/?source[]=FirstThingUID&source[]=SecondThingUID
- Record path: Choose Data.
Figure 4. Data Table tab plugin settings
Click Generate Columns, and then click Refresh Preview.
The columns are populated and the requested data is displayed.

Figure 5.
Click Save.
Click Back to return to the Edit Dashboard view.
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.
Select the Visualization mode and configure it using the Visualization settings.
Detailed information regarding Data Tables is available from the Panopticon Designer documentation.