In this tutorial, we'll drill down on the data to further analyze it. This is possible using indicator drills.
What you'll create
An indicator drill inspecting the
Creating a indicator drill
We already have
empty_indicator_drill in our project from the first tutorial, which served as a placeholder so far. Let's create a copy of it and add in some blocks.
copyMetadata command to create a copy of the object.
Now, edit the
business_overview_dashboard.json so that the
turnover_indicator is paired with the new
turnover_indicator_drill and use
pushProject to push the changes.
The content of turnover_indicator_drill is still empty so far.
Add a distribution block and push the changes. This block tells you the distribution of data across the map.
The distribution block has now appeared in the indicator drill.
This block has the
onDashboard property set to true, which means it will also be present on dashboard! This is another addition which can help you spice up your dashboard.
Add a ranking block and push the object. This block orders all objects in the map based on the value of selected indicator.
The ranking block has now appeared in the indicator drill.
Time series block
Add a time series block and push the object. This block allows you to see the progress and trend of an indicator in a selected time frame.
The time series block has now appeared in the indicator drill.
The categories block allows you to list specific classes of data within a single indicator. It offers more configuration than the other blocks and can have many varieties.
We will add 3 different categories blocks to explore the possibilities.
dualProperty - age pyramid
In all cases, a
splitProperty (property by which data will be split),
description must be specified.
- in case of age pyramid - we have to add
dualProperty, and a
- in case of basic categories - we will not extend the object, but it's possible to make it e.g. condensed by setting the
condensed property to true
- in case of vertical categoreis - we have to set the
vertical property to true
The categories blocks have now appeared in the indicator drill.
You may have noticed that a Visualize icon appears when you hover the basic categories or vertical categories. This icon enables the qualitative visualization.
Qualitative visualization allows you to colorize objects on the map with a set of predefined colors, based on prevailing category of this object. The object can be an area, grid, zone, line, or a dot.
Some colors are assigned by default. In case of our project, we'll set up the areas with prevailing Online channel to be visualized as green, and Offline as red. The setting is done in the
dwh.ref.properties.displayOptions object of the dataset property specified in the
splitProperty of the categories block. You can pick any color you like from the given palette (purple, green, orange, blue, turquoise, pink, red, lime and brown).
Click on the Visualize icon and the map will become colorized.