• Overview
• How to create a Dashboard?
• Examples

Overview

How to create a Dashboard?

1. Add series and perform calculations.
2. Add Bar chart and open Graph layout (Ctrl+L).
3. Arrange series the way you want. Each section in Graph layout is a new column:
   • Note that those transparent yellow and blue colors do not appear in the application.
4. Rename columns and titles.
   • If you need to add a dynamic date - add to Series list: Month() and Year(), and as another Group in Cross sampling. When editing column's title use those series in i.e.,: Data for {s s7.Value}/{s s6.Value}.
5. Add Rules - see Bar chart conditional formatting rules and the example below.
   • If you want to highlight whole column in one color - set rule that will always be true, for example 'Greater than -1' (for a series that cannot go below 0).
6. Set width for each section - click on a cell in column and go to Column properties > Column.
   • Note that this is made for 'Expanding' mode. You can change the mode under Chart properties > Width
7. Add separator between sections - click on a column and go to Column properties > Separator left/right, select Color and Width.
8. Add general border - go to Graph area properties > Border, select Color and Width.
9. Add notes - go to Chart properties > Notes, select one of them and type in text. 

Examples

Dashboard - Tourists expenditures

In this example we compare average expenditures from past years to latest month values.

Dashboard - Land use

In this example we compare land area (forest and agricultural) of different countries.