A Heatmap Table is a two-dimensional graphical representation of data in which values are displayed or represented by colors.
When having a large volume of data, it is important to visualize and focus on the most relevant values according to your needs. The Heatmap table Widget allows you to simplify complex data into visualizations that can be easily understood and identified.
Requirements
An active Ubidots account (Industrial license and above).
Table of contents
1. Create a Static Heatmap Table Widget
Head to the "Data" dropdown in the Navigation bar, then "Dashboards", and select the appropriate dashboard to be working on. Next, follow the steps below to create a static Heatmap Table Widget:
Step 1: Click on the top-right “+” button in your dashboard.
Step 2: Select the Heatmap Table Widget.
In the settings tab of the widget:
Step 3: Choose the Y-Axis, here you have two options:
Days of the month
Days of the week
Step 4: Click the “add variable” button and select the variable you’d like to visualize the data from.
Step 5: Set all the available fields:
Aggregation method
Span
Set the Color logic
In the appearance tab of the widget, you can edit extra fields:
Step 6: Set all the following fields:
Name your Heatmap Table Widget.
Choose the date format.
Choose the Hour format (12 hours or 24 hours)
Set the Decimal places.
Enable/disable the Show legend option.
Enable/disable the Hide values option.
If any, enter a Custom Style for your widget.
2. Create a Dynamic Heatmap Table Widget
Similar to section 1, head to the "Data" dropdown in the Navigation bar, then "Dashboards", and select the appropriate dashboard to be working on. Next, follow the steps below to create a dynamic Heatmap Table Widget:
Step 1: Click on the top-right “+” button in your dashboard.
Step 2: Select the Heatmap Table Widget.
In the settings tab of the widget:
Step 3: Choose the Y-Axis, here you have two options:
Days of the month
Days of the week
Step 4: Click the “add variable” button and select the variable you’d like to visualize the data from.
Step 5: Set all the available fields:
Aggregation method
Span
Set the Color logic
In the appearance tab of the widget, you can edit extra fields:
Step 6: Set all the following fields:
Name your Heatmap Table Widget.
Choose the date format.
Choose the Hour format (12 hours or 24 hours)
Set the Decimal places.
Enable/disable the Show legend option.
Enable/disable the Hide values option.
If any, enter a Custom Style for your widget.
