Page Comparison

The Squirro Dashboard allows configuration of various data visualizations, based on the current Squirro project and data set.

The following widgets, each with its own visualization, are available to configure inside the Dashboard.

Table of Contents

Pie Chart

Image Removed

The Pie Chart is used to display values of a specific facet in a pie format, a pie chart legend can be enabled if required through the settings.

The only configuration required is the facet, which values are populated on the chart.

Cloud Chart

Image Removed

The Cloud chart displays values of several (between 1 and 6) different facets at once. 

Each facet can be assigned a disired colour in which it is displayed on the chart.

Line Chart

Image Removed

The Line chart displays facet values of one facet in the form of a time based line chart.

This is be particularly useful if the dataset contains dates in one of the facets.

The only configuration required is to provide a facet to display on the chart.

Keywords

Image Removed

The Keywords list displays the top keywords for a facet, in a list format, with the number of matches in analysed documents, aswell as percentage based part of the set they represent.

To configure, provide a facet which values to display on the chart.

Significant Terms

Image Removed

The Significant Terms provides visual information about terms which are especially significant in a dataset, comparing to another dataset.

Significant Terms allow to reveal the uncommonly common. This means, that it shows which terms show a significant different value distribution in a foreground-dataset when compared to a background-dataset. This requires a certain amount of documents to work, the more terms there are in a facet, the more documents are needed to get a meaningful answer. In Squirro the background-dataset is what is defined in an unmodified dashboard. The foreground-dataset is constructed from the background-dataset and includes the current selection. If there is no selection, meaning that the foreground- and the background-dataset are equal, the term frequency is shown (except if the facet is body, title or summary where this operation is too costly).

Significant terms work very well on facets with few values, meaning if computed on a body, title or summary field, there are much more documents needed to get a significant term to show-up. One workaround for this restriction is to use phrase- or term detection and index those phrases/terms in a separate facet field. This has shown to improve the results vastly while also not requiring a lot of documents.

The Significant Terms configuration for facet content fields looks like the following:

Image Removed

When configuring over a special content field (body, title, summary), one is asked also to provide language and the maximum number of results returned.

The maximum number of results field affects performance, so exercise with caution when increasing the limit.

Frequency

Image Removed

Result List

Image Removed

The Result List widget simply displays a list of results, as seen on the Search page. Clicking on a result will show its content in a pop-up window.

The widget works out of the box without any configuration, though it is possible to change quite a few features, including query/smartfilter highlighting, and the way items open on click (new window, modal window, with moving to the first matching pdf page in the case of a pdf document).

...

Image Removed

The iFrame widget allows embedding websites into the Squirro Dashboard. The configuration has one parameter only, the URL.

In order to embed a website as an iFrame, it must itself support that via X-Frame-Options, aswell as being served via the same protocol as Squirro itself (http / https).

The URL must be well formatted, including the protocol (eg. http://www.squirro.com).

There are several parameters in the URL that one can use to extend the functionality. Using those optional parameters allows a limited channel of communication to be created between Squirro and the embedded webpage. 

• %s - will be replaced by the current Dashboard query when resolving the URL.
• %tb - will be replaced by the beginning of the current Dashboard time range (if one is defined).
• %ta - will be replaced by the end of the current Dashboard time range (if one is defined).
• %u - will be replaced by the currently logged in user's name.
• %p - will be replaced by the current project's title.
• %d - will be replaced by the current (containing the IFrame widget) dashboard's title.
• %q[query_param] - will be replaced by the embedded dashboard's URL query param of the name query_param.
  This is particularly useful in scenarios where the embedded dashboard gets injected some parameters from the outside environment.
  By referencing them in the iFrame widget, it is possible to trickle them down to the referenced web endpoint. 

Search Query

Image Removed

The Search Query widget is essentially a Squirro Search box, with the exception that it's aimed at refining the current dashboard query, rather than fully controlling it.

Any query put into the widget will be combined with the current dashboard selection using an AND operator.

Heat Map

Image Removed

The Heat Map is a convenient way to represent the aggregations between two facets present in the project. During the configuration, facets for both of the axis are chosen, as well as the maximum size of the resulting matrix (the actual heat map). The data generation first resolves top values for the first facet, then for each of the top values aggregates over the second chosen facet, determining the weight of the connection between both facets. The weight determined is then used to present the number of mentions of both facets in items, present at the same time.

Clicking on a box in the heat map will drill down the current query to items which satisfy both facet value conditions as per the clicked box.

Additionally, it is possible to specify both the starting and ending color point for the Heat Map gradient, the starting point being the color applied to lowest values (mention counts), the ending point being the color applied to highest values. Color for all intermediate values is determined automatically via interpolation.

Facets Table

Image Removed

The Facet Table widget is used to display values of specific facets for every document in the result list.

It allows any combination of facets to be configured, resizing the columns with facet values, as well as sorting the entire dashboard (and subsequently, the widget itself) by any facet.

Facets List

Image Removed

The Facet List widget allows to display any combination of facets, and select specific facet values.

Hovering over the facet field displays the distribution of actual facet values, sorted by top 10 values.

Clicking on an individual value filters the result list. Multi-selection of values is supported as well by pressing the modifier key, Cmd for Apple Macs, Ctrl for Microsoft Windows systems.

Horizontal Result List

The Horizontal Result List shows the list of items, according to dashboard selection, in a horizontal, CoverFlow-esque control, with a left/right navigation.

Configuration is mostly same as the vertical Result List widget, supporting opening the item details in modal window, as well as query / smartfilter highlighting.

The widget also shows the number of duplicated items for each item in the top-right corner, should such items exist and duplicates have not been disabled in the widget's configuration.

Image Removed

Trend

The Trend widget is used as part of the Trend Detection to visualize the trend, anomalies and predictions for data in a project.

Image Removed

Custom

New widgets can be created and made available using the Custom Widgets APIThis page can now be found at Built-In Widgets on the Squirro Docs site.