2.Building_visualisations.md

Exercise 2: Building Visualizations

In this exercise we will build charts, numeric pointers and input control filters to analyze

1. Top 10- Consumers(kWh)
2. Top 10- Consumers Inactivity Time(Hours)
3. Bottom 10- Consumers Effective Charging
4. Consumption (kWh) / Cost (€) per Charging Station
5. Errors per Charging Station
6. Total Consumption(kWh) / Total Cost(€)
7. Charging Sessions/Charging Duration

You will find the definition of each of the above KPI in the respective section. For the rest of the pages, we have included the KPI definitions in the Appendix.

At the conclusion of this exercise your story will look similar to the image below

Building Visualizations:

Expand the Navigation bar (If not already expanded)

Select Files and then Public folder

Search for folder TechEd2021

Select story E-mobility

Click Copy

Select Folder : Analytics Cloud and Name it as E-mobility-XXXXXX (replace XXXXXX with your given login ID)

❗️ Important: Please ensure you are in the Analytics Cloud folder.

click on OK

Go to Files, click on Analytics Cloud, you will see the story saved.

Click on the E-mobility-XXXXXX story to launch.

You see blank KPI's without data.

Let's start building the first KPI:

Top 10 - Consumers (kWh)

This is to visualise Top 10 employees with the highest consumption in kWh over the selected time period.

Select the Top 10 – Consumers Tile and then select “Edit” and “Designer” to see the Builder properties window

Now select +Add Measure: Consumption in kWh

Dimension: UserName (Can search using the searchbox)

Select 3 dots on the chart tile and click on Rank- Top N options

Type value= 10 and Apply

We have built the Top 10- Consumers by Consumption(kWh) KPI chart

Top 10- Consumers Inactivity Time(Hours)

This KPI indicates how long the user is still plugged in but no longer charging. A notification can be sent to an user to free up the charging station when charging has been completed.

Let's build the second KPI: Top 10- Consumers Inactivity Time(Hours)

Click on the Top 10- Consumers Inactivity Time(Hours) Tile.

 ( Note:  When you click on the Tile, you should see the Designer Tab, if not click on Designer tab to see the Builder properties window )

Select +Add Measure and select Inactivity(hrs)

Dimension: Username

Select 3 dots on the chart tile and click on Rank- Top N options

Type value= 10 and Apply

We have built the Top 10- Consumers Inactivity Time(Hours) Chart

Bottom 10- Consumers Effective Charging

Effective Charging is a KPI that indicates the ratio between charging station being utilised and inactive.

Click on the Bottom 10- Consumers Effective Charging tile and then bring the Designer Tab, you see the Builder properties window

Select Measure: Effective Charging(%) and

Dimension: Username

Select 3 dots on the chart tile and click on Rank- Top N options

Select Mode= Bottom

value= 10 and Apply

Now let's add Threshold to see the effective (%). With Thresholds we can define conditional formatting.

Click on the 3 dots, click Add and select Threshold

On the Threshold properties window, Select Measure Effective Charging(%) from the drop down list

On the Thresholds, add range by clicking + Add range option (click 2 times) to add different ranges for

Now set the range as below and click on Apply:

Green(Ok)= 70 to 100

Orange(Warning)= 50 to 70

Red(Critical)= 0 to 50

Now, click on measure Effective Charging(%) threshold icon, select Show Threshold and select Story Defined option

You will notice the Threshold values in different colors as defined.

We have built the Bottom 10- Consumers Effective Charging chart

Consumption (kWh) / Cost (€) per Charging Station

Here we can see the cost and consumption per charging stations.

Click on Consumption (kWh)/Cost(€) per Charging Station tile and then the Designer tab, you see the Builder properties window

Select Measure as : Consumption in kWh and Cost(€)

Dimension as: ChargeboxID

Select 3 dots on the chart tile and click on Rank -> CHARGEBOXID -> Bottom5

We have built the Consumption (kWh) / Cost (€) per Charging Station chart

Errors per Charging Station

This is an important KPI to monitor if the charging stations are having any issues. If an errors is present, the administrator can restart the charging station and check if the issue resolves.

Click on Errors per Charging Station tile and then the Designer tab, you see Builder properties window

Select Measure: Errorcount and Dimension as ChargeboxID

We have built the Errors per Charging Station chart

(Note: All the values are Zero as there are no Errors per Charging Station seen)

Total consumption/Total Cost - Numeric pointer

Here we can see a numeric values for total Consumption in kWh and Cost in euros over the selected timeframe. This KPI automatically updates when a different timeframe in the filter is selected

Click on the numeric point tile and then the Designer tab, you see Builder properties window

Add measures Consumption in kWh and Cost(€)

You will see the output as

Charging sessions/Charging duration: Numeric pointer

Here we can see a numeric values for total nr of Charging Sessions and Charging Duration. This KPI automatically updated when a different timeframe in the filter is selected

Click on the numeric point tile and then the Designer tab, you see Builder properties window

Add measure: ChargingSessions and Charging Duration(hrs)

You will see the output as

Lets add Linked Analysis feature with the Input control to the story:

Click 3 dots on the Input control tile... then select Linked Analysis. Linked Analysis feature allows us to perform dynamic interaction between widgets.

On the Linked Analysis properties window, select "All Widgets on the Page" option and Apply

Now, you can select and deselect the SITEAREA to see the different interactions on the chart/values

You have built the final story.

Click on Save

This completes Exercise 2 Building Visualizations

Exercise 3. Geographic Visualisations