Siren Platform User Guide

Datasource entity selection

It is possible to select a company entity (record) in the SQLite database (and entities in external datasources in general) by clicking its label in the Companies Table.3.12. Legacy REST datasources

The selected entity can be used as a parameter in queries; for example, click Browshot in Companies Table:3.12. Legacy REST datasources

Entity selection

Selecting an entity enables additional queries on external datasources. For example, in the Query on Companies visualization you can see that, amongst the top 500 companies by number of employees mentioned in articles about wireless or Wi-Fi, Browshot has 487 competitors and there are nineteen companies in the same domain. All widgets affected by the selected entity are marked by a purple header.

For the Y-axis metrics aggregation, select Unique Count, with speaker as the field. For Shakespeare plays, it may be useful to know which plays have the lowest number of distinct speaking parts, if your theater company is short on actors. For the X-Axis buckets, select the Terms aggregation with the play_name field. For the Order, select Ascending, leaving the Size at 5.

Leave the other elements at their default values and click Apply Changes (fa-play.png).

Selecting an entity also enables the display of additional data in the Company Info visualization; by clicking the (show) links you can toggle the list of companies in the same domain and competitors. The data in the tables is fetched from queries on the SQLite database, using the selected company ID as a parameter. The queries are rendered using customizable templates, which will be introduced later.3.5.3 Siren Investigate query viewer

The selected entity appears as a light blue box on the right of the filter bar; to deselect an entity, click the bin icon displayed when moving the mouse pointer over the purple box.

For more information about entity selection, see 3.12. Legacy REST datasources.3.12. Legacy REST datasources