In the previous blog post, we did not only explained how the visualising tool Klipfolio is constructed and which basic functions you can use for creating dashboards and Klips, but also showed you how to illustrate specific online data on a map via the visualising tool.
With this blog post we would like to enhance our simple map dashboard with a new element: the bar chart. The bar chart comes in handy if you want to visualise temporal processes or traffic sources (site views, transactions, etc.). Operating with this chart, the user of the dashboard has the option to determine the location of the performance traffic and furthermore to monitor the progress of key figures in a specific time.
Creating a bar chart in Klipfolio
To add a bar chart to our Klip we prepared on the previous blog post, open the dashboard, click on the menu button and choose “edit” (See Figure 1).
Figure 1 : Klipfolio – Select Dashboard Menu
The Klip Editor is going to start and we should be able to select the bar/ line chart from the right, where all the diverse Klip Display Options are located.
Figure 2: Klipfolio – Bar Chart Klip
Drag the Klip below the Map Klip. Within the folder structure of the Klip Editor, you are able to configure the bar chart Klip
Figure 3: Klipfolio – Klip Configuration
Adjusting the name of the clip for better identification as a first step of configuration is recommended. This can be done by clicking the three points (more Action Button) next to the bar / line chart (see Figure 3).
We are going to name this bar chart Klip “Bar Chart – App Downloads”, because we would like the number of the app downloads to be displayed – as it was shown on the Map – by country.
Load the bar chart with data
In order to visualise the downloads using the bar chart, click on “Series Untitled”, which is under the “Bar chart – App Downloads” at the Klip Editor and select “Data” (see Figure 4).
Figure 4: Klipfolio – Klip Configuration Data
Now left click at the input area of the Data window and enter the following formula:
Thus, we summ up the count of downloads (column b) of all countries set on the sheet from fig. 5 (column C and optionally also column D), which might occure more than once (per country, there can be more than one company who downloaded the app)
Figure 5: Klipfolio – imported Excel Sheet
In order to receive an accurate display of the values of the x-axis,
press on “x-Axies” and enter the following formula to define the proper depiction of the values from the x-axis:
We arrange all values, except the title of gap C. You can optionally choose gap D instead of gap C, whereby only the country abbreviations will be shown on the x-axis.
Figure 6: Klipfolio – Bar chart
Formatting the bar chart – filter and sort
The depiction of figure 6 is not that helpful, because a high quantity of countries is shown, which cause the image to be unclear. Hence, sorting the view by the number of downloads, this issue will be solved elegant.
Therefore, we press on ‘‘Series‘‘in the Klip Editor, go to ’’Properties’’ and select the function ’’Sort’’ from the drop down menue (see fig. 7).
Figure 7: Klipfolio – Sort data
We choose the sorting option “from highest to lowest”.
Another option to sort the data would be the use of the Sort () function below the index tab “Data”.
In order to display only countries with at least one download from a company, we can use the filter function from Figure 7 in the “Properties” index tab for “Series”.
Figure 8: Klipfolio – Filter function
To accomplish this task, click on “Filter” and change from the “Range” tab to the “Condition” tab. In the next step, we select the condition, which, in our case, includes all values greater than or equal to one.
Even the filter could be realised by a function, namely via ’’Select’’ or an extended ’’Groupby’’ formula.
- For Series: Select(Groupby(Slice(@CHART1,C:C),Slice(CHART1,B:B)),Groupby(Slice(@CHART1,C:C), Slice(@CHART1,B:B))>0)
- For x-Axis: Select(Group(Slice(@CHART1,C:C)),Groupby(Slice(@CHART1,C:C), Slice(@CHART1,B:B))>0)
The description of these formulas “Select” as well as “Groupby” will be described in more detail in the next blog entries.
Figure 9: Klipfolio Dashboard – Map & Bar Chart
It might be useful to copy this bar chart and define a filter for the two charts in Klipfolio. For this diagram, only values greater than the 0.75 quantile value are ahown. The second diagram shows only values less than the 0.75 quantile value.
This allows the top performance countries to be identified faster for the management.