Dashboards

Top 

PTSS Company Logo

 

Dashboards

 

 

Dashboards is a feature in SpatialXL and all our spatial products that allows you to get various graphs and data out of your spatial data in graphics for analysis.

 

 

 

DASHBO~1_img2

 

 

Dashboards can also be accessed from the View tab and selected if it is not present as a tab next to Layers.

 

 

DASHBO~1_img3

 

Licensing

 

To create Dashboards, you require a Bi description in your license file. If you do not have this description in your license file, you will only be able to view Dashboards that have already been set up.

 

DASHBO~1_img4

 

Designing Dashboards

 

Select the Dashboards tab and click on Add a Dashboard.

 

 

DASHBO~1_img5

 

A window will come up. Click on Yes.

 

 

DASHBO~1_img6

 

The Dashboard Designer will open now.

 

 

DASHBO~1_img7

 

 

Choose the appropriate Data Source that you would like to create Dashboards for. In this example I chose the layer POP CENSUS SUB PLACES as my Data Source.

 

 

DASHBO~1_img8

 

 

In the Home tab is where you can select in what form you want your information to be displayed. Chart is chosen in this example.

 

DASHBO~1_img9

 

 

All the columns that are in the POP CENSUS SUB PLACES layer are displayed. Choose a column you would like to display on the Chart you selected. I chose DOM_AGE. Click and drag this column onto the Value block under Values in the DATA ITEMS section.

 

 

DASHBO~1_img10

 

 

DOM_AGE value is by default (Count) as this column doesn’t have purely numeric values to do (Sum) etc.

 

To display the different age categories, select DOM_AGE again and drag it onto Argument block under Arguments.

 

 

DASHBO~1_img11

 

Right click DOM_AGE under Arguments where you can choose how to arrange your data on the Chart. Sort Ascending is chosen in this example.

 

Continue choosing and dragging columns in this way that you want displayed on the Chart.

 

DASHBO~1_img12

 

You can rename DOM_AGE(Count) and DOM_LANG (Count) Values that are displayed on the Chart by right clicking and selecting Rename.

 

 

DASHBO~1_img13

 

 

 

DASHBO~1_img14

 

 

To change the name of Chart 1, right click anywhere in the chart area and select Edit Names. A window will open where you can change the name of your Chart etc.

 

 

DASHBO~1_img15

 

 

 

DASHBO~1_img16

 

You can add various graphs, charts, etc. to be displayed on your Dashboard at the same time.

 

Next example is to select Gauges from the Home tab.

 

DASHBO~1_img17

 

 

Click on MALES and drag it onto the Actual block under Gauges under DATA ITEMS. Do the same with the FEMALES column onto the next Actual block.

 

DASHBO~1_img18

 

The default operation as you can see is (Sum) for both the columns as they only contain numeric values. You have an option of right clicking MALES (Sum) and FEMALES (Sum) and choosing a different operation from the list like Average etc.

 

DASHBO~1_img19

As you can see on the Gauges above, the format is R (Rand) which is not applicable for the data I want to display. To change this, click on the cog wheel next to MALES (Sum) and select the Format tab. Select Actual value then for Format type, choose Number. Click OK.

 

DASHBO~1_img20

 

Do the same for FEMALES (Sum). (Note: There are many other settings you can adjust in the Gauge Options window.)

 

DASHBO~1_img21

You can even choose a different Gauge design by going to the Design tab and selecting the appropriate option.

 

DASHBO~1_img22

 

Gauges 1, MALES (Sum), and FEMALES (Sum) can be changed per the above instructions.

 

Dominant Chart and Gauges 1 set up thus far have been from the same Data Source POP CENSUS SUB PLACES. In the next example, I am choosing another Data SourceSALES AREAS which is also one of my layers.

 

I would like to add a Text Box this time for my Dashboard.

 

DASHBO~1_img23

 

I would like the average population count, so I set this up under DATA ITEMS as described previously.

 

DASHBO~1_img24

 

Type in any text you would like in Text box 1 — Double click in this box to be able to do this.

DASHBO~1_img25

 

Move your cursor in this box to the point where you would like to insert values. Right click there and select Insert Field. Select value will now show.

 

DASHBO~1_img26

Click Select value. I had only set up one field POP_COUNT (Average) in this example so I will click on it to choose it. If you had more than one field set up, then you could choose what you wanted to insert.

 

DASHBO~1_img27

 

POP_COUNT (Average) will be displayed.

 

 

DASHBO~1_img28

 

If you click out of Text Box 1 on another area on your Dashboard, you will see the actual number for POP_COUNT (Average). This is the average population of the entire layer data.

 

 

DASHBO~1_img29

 

At this point you could consider your Dashboard complete. There are many other features in the Dashboard Designer that are available. Only the very basics were gone through. Understanding the above, the rest is self-explanatory.

 

Click on Save to save your current Dashboard.

 

 

 

DASHBO~1_img30

 

Click on Save As to save your Dashboard as a Dashboard file.

 

DASHBO~1_img31

 

Click on Open to open a previously saved Dashboard file. (Note: If you try and open a Dashboard file that was created from another workbook with different layers, it won’t display saved data correctly.)

 

When you first opened Dashboard Designer an item New DashBoard was automatically added to the Dashboards tab.

 

 

 

DASHBO~1_img32

 

 

 

Since you are complete with designing your current Dashboard, you can close the Dashboard Designer window and click New Dashboard where you can change the name of your Dashboard.

 

 

DASHBO~1_img33

 

Viewing Dashboards

 

Click on the View Dashboard icon to view the dashboard that was just set up – Dashboard Test. If you had another dashboard set up, you would first select that dashboard then click on View Dashboard.

 

DASHBO~1_img34

 

 

The Dashboard Viewer window will open. The numbers being displayed are totals of all the data. Filter on Selected is not checked on.

 

DASHBO~1_img35

To get out numbers of selected items, check on Filter on Selected.

 

DASHBO~1_img36

 

There is no information displayed here yet as no items have been selected yet on the graphics. Go to the Layers tab and ensure the layer that is referenced as the Data Source for your Dashboard is checked on.

 

DASHBO~1_img37

Now select an area or areas using one of the selection tools. The exact numbers for the selected areas will be displayed on the Dashboard Viewer.

 

 

DASHBO~1_img38

 

 

Note: Text Box 1 number will not be displayed if Filter on Selected is checked on as this was created from a different Data SourceSALES AREAS.

 

 

To display the value in Text Box 1, ensure SALES AREAS is checked on in the Layers tab. Then using one of the selection tools, select 2 or more areas from this layer. The average population number will then be displayed.

 

DASHBO~1_img39

 

No data will be populated for the other items on the Dashboard Viewer as the Data Source is the layer POP CENSUS SUB PLACES for them. Only areas from the SALES AREAS layer are selected.

 

If you would like to change any design in any Dashboard from the Dashboards tab, select the appropriate Dashboard and click on the Design Dashboard icon where you can do this. Save your settings.

 

 

 

DASHBO~1_img40

 

You can add as many different Dashboards as you want here by clicking DASHBO~1_img41.

 

To delete a Dashboard, first select it then click DASHBO~1_img42.

 

You can inspect the data of the various charts etc. set up on your Dashboard by selecting the Inspect Data icon.

 

 

 

DASHBO~1_img43

 

Click on the Maximize button DASHBO~1_img44 to expand any chart etc. to the full area of the window.

 

 

You can Export each chart etc. to Image, Excel, or PDF. You can even get a Print Preview. You do this by clicking the Export To icon above each chart etc. and then selecting the appropriate option.

 

DASHBO~1_img45

 

To Export or have a Print Preview of the entire Dashboard, select the Export To icon on the top of the Dashboard.

 

Note: First expand the entire Dashboard window so you can see all items otherwise it will be cut off when exporting.

 

 

DASHBO~1_img46

 

 

Publishing Dashboards to Spatial Reader Files

 

You need a specific description in your license file to publish Dashboards to Spatial Reader files. If you do not have this description in your Spatial Publisher license file, you will be able to publish everything else in the spatial product you are using except for Dashboards.

 

 

 

DASHBO~1_img47

 

 

 

 

 

 

 

Support

 

clip0001 

 clip0002

T:  +27871354351

 

support@primethought.biz  - primethought.biz

Kyalami Estate, Midrand, Johannesburg,

1684, South Africa

clip0003clip0004clip0005clip0006clip0007clip0008clip0011