Page tree
Skip to end of metadata
Go to start of metadata

Dashboards are visual representations of data. Squirro supports extensive dashboarding functions, allowing you to have real-time visual representations of data as you search.

Table of Contents

Creating dashboards

To create a dashboard, 

  1. Open the Dashboard page by clicking on Dashboard in the top menu.
  2. Click on the + sign at the end of the list of existing dashboards.



  3. Alternatively, you can use the save button's dropdown to create a dashboard from the current search query.



  4. Name your dashboard and provide an initial query (you can change both the name and the query later on). To include all documents, leave the query empty.



  5. Press SAVE.
  6. Directly after creation, you are presented with a fresh dashboard, an empty widget and a configuration panel for it.

  7. Continue with the next sections to learn how to configure the newly created dashboard.

Editing dashboards

To enter editing mode,

  1. Click on the pencil icon in the top right corner of the dashboard:



  2. You are now in editing mode.

Change title and query of dashboard

To change your dashboard's main query or title,

  1. Enter editing mode using the steps described above,
  2. In the edit sidebar to the right, open the Dashboard section



  3. Enter the title and query as desired.

  4. 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,

  1. Enter edit mode on the dashboard,
  2. In the edit pane on the right, press the plus button next to the "Widgets" header.



  3. Set a title and the widget type to use in this form.



    See the Widgets documentation for information about the various widget types.

  4. Depending on the widget type, additional configuration options may be displayed and required.
  5. Changes made in this form are applied immediately to the dashboard, but not yet saved.
  6. To save the changes, use the Save Dashboard button at the top of the edit sidebar.

Moving widgets

To move a widget,

  1. Enter editing mode as described above,
  2. Click on the handle in the middle of the top frame of the widget,
  3. Drag widget using the handle.

Editing widgets

To edit a widget,

  1. Enter editing mode as described above,
  2. Click on the pencil icon in the right upper corner of the widget's frame,


     
  3. The widget is activated in the edit panel on the right side of the screen.



  4. Changes made in this form are applied immediately to the dashboard, but not yet saved.
  5. To save the changes, use the Save Dashboard button at the top of the edit sidebar.

Deleting widgets

To delete a widget,

  1. Enter editing mode as described above,
  2. Click on the delete icon in the right upper corner of the widget's frame,



  3. Confirm the deletion in the resulting dialog.

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 StringResult for a facet value of 123456.789
%dEUR123456.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 StringResult for a facet value of 123456.789
%'dEUR123'456.789EUR
%.,dEUR123.456,789EUR
%',dEUR123'456,789EUR

 

It is also possible to specify the rounding precision of floating point values, after the floating point.

Formatting StringResult for a facet value of 123456.789
%2dEUR123456.79EUR
%,1dEUR123456,8EUR
%',0dEUR123'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,

  1. Click the Dashboard Setting Button and select "Share Dashboard" or "Embed iFrame"



    The Embed iFrame offers an iframe HTML tag, which can be used for embedding the dashboard in a 3rd-party web site or application. The Share Dashboard option offers a URL, which can be easily shared via email or other means.

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.

ParameterDescriptionExample Value
queryOverride the Dashboards search query as documented here.&query=(blue OR green OR red)
selectionSet the Foreground query for all Significant Terms widgets&selection=blue
created_beforeOnly display results with a created_at value lower than this

&created_after=2012-12-31
&created_after=2012-12-31T18:30:00

created_afterOnly display results with a created_at value higher than this&created_before=2014-12-31
&created_before=2014-12-31T18:30:00
relative_startOnly display results with a created_at value higher than this, in relative terms to today

&relative_start=2y
&relative_start=8w

relative_endOnly display results with a created_at value lower than this, in relative terms to today&relative_end=1y
&relative_end=4w 
  • No labels