Dashboard Editor is a tool offered by Squirro which allows you to build meaningful dashboards by adding widgets and configuring them. The tool also exposes the conditional layers in the user interface where a layer is made visible when it satisfies a certain visibility condition.
Table of Contents
| Table of Contents | ||||
|---|---|---|---|---|
|
Creating dashboards
To create a dashboard,
...
Directly after creation, you are presented with a fresh dashboard where some widgets are put together to give you a head start, along with a link to the documentation to the widgets.
...
Continue with the next sections to learn how to configure the newly created dashboard.
Dashboard Editing Interface
- On creating a new dashboard, you automatically land on the edit mode of the dashboard.
- The navigation bar shows you the Project name and the dashboard name.
- In the center of the nav bar are toggle buttons which allows you to switch between the desktop and the mobile version of the dashboard. More about the mobile dashboard editor here.
- On the right of the nav bar, there is a switcher button which allows you to switch between the edit and the view mode of the dashboard. Clicking on 'Exit' button exists the editor and takes you back to the list of dashboards.
- The dashboard editor consists of two panels, the tree panel on the left and the properties panel on the right.
- The tree panel lists the entities like dashboard, layers and widgets while the properties panel displays the config. options to configure the entity selected from the tree panel.
- The properties panel has a L | R button which allows you to switch the positioning of the properties panel to the left or the right of the screen. The system also remembers your preference for the panel positioning.
- At the bottom of the tree panel are the buttons to add a new layer or a new widget to the dashboard.
Dashboard Properties
To change your dashboard's main query or title,
...
Enter the title and query as desired.
...
Once done, press the Save Changes button at the top to save your changes or press Cancel to abandon them.
Widgets
Widgets are the building blocks of a dashboard. Each widget represents data in a particular form. Currently, Squirro offers a number of built-in widgets, such as pie charts, time frequency graphs (line charts) and word clouds.
Widget types
The available widget types are listed on the page Widgets.
Add widget
To add a widget,
...
Moving widgets
To move a widget,
...
Editing widgets
To edit a widget,
...
Deleting widgets
To delete a widget,
...
Facet Value Formatting
It is possible to format the values of numerical and date facets to be displayed in the dashboard widgets.
To do so, one can define the facet formatting screen in the Facets management section of Squirro.
Formatting of numerical facets (of type int or float)
The string defined in 'Format' section will be used to display the facet values in Dashboarding. Any string can be used to that purpose, and a preview of the formatting is visible to the right of the format input field.
To inject the actual facet value into the resulting string, %d placeholder is used.
Formatting String | Result for a facet value of 123456.789 |
|---|---|
| %dEUR | 123456.789EUR |
| $%d | $123456.789 |
Additional formatting options are available for the %d placeholder, allowing to define the separator between each magnitude of 1000, as well as the symbol used to the floating point, in the case of values of float datatype.
Formatting String | Result for a facet value of 123456.789 |
|---|---|
| %'dEUR | 123'456.789EUR |
| %.,dEUR | 123.456,789EUR |
| %',dEUR | 123'456,789EUR |
It is also possible to specify the rounding precision of floating point values, after the floating point.
Formatting String | Result for a facet value of 123456.789 |
|---|---|
| %2dEUR | 123456.79EUR |
| %,1dEUR | 123456,8EUR |
| %',0dEUR | 123'457EUR |
Formatting of facets of type Date
To format facet values containing dates (and times), Squirro offers three formatting options, defined in the Facets configuration screen.
Each option is accompanied with a preview of the resulting formatted value.
Embedding and Sharing Dashboards
To share or embed the current dashboard,
...
Dashboard URL API Reference
The URL which is generated by the Embed and Share options in the dashboard can be extended with additional options. The following URL parameters can be used to change the behavior of the dashboard.
...
...
...
...
&created_before=2014-12-31
&created_before=2014-12-31T18:30:00
...
&relative_start=2y
&relative_start=8w
...
This page can now be found at Dashboard Editor on the Squirro Docs site.