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 Property 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.
- From the left menu, click .
- 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 Datasources highlighted, under File/URL, select Altair IoT Studio.
Figure 3. File/URL 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.