Striim 3.9.4 / 3.9.5 documentation

Main page vector map
Screen_Shot_2016-01-05_at_12.24.56_PM.png

To view a query for a visualization, click Edit Query. When done click x to exit.

image4.png

The basic query for this map is SELECT * FROM MerchantActivity ORDER BY StartTime, which gets all fields from the MerchantActivity WActionStore. The ORDER BY clause ensures that the map looks the same every time you run the application.

To view the properties for a visualization, click Configure. When done click x to exit.

image8.png

The fields are assigned to map properties as follows:

Screen_Shot_2016-01-05_at_12.27.22_PM.png

Data Retention Type = Current means the map shows the latest events for each map point. Group By CompanyName means each company gets a single dot on the map. Color By Category means the colors are based on the Category field value (more about that below). The Longitude and Latitude properties are set to the fields with the coordinate values. Value = Count means that the size of the dot on the map varies according to the number of transactions in the company's latest event.

The colors of the map points are set manually:

Screen_Shot_2016-01-05_at_12.31.21_PM.png

If the map had a legend, it would use the alias strings:

Screen_Shot_2016-01-05_at_12.37.21_PM.png

See Vector map for more information about these settings.

Screen_Shot_2016-01-05_at_12.23.13_PM.png

The map's title is a "value" visualization, which can add text, query results, and almost any valid HTML to a dashboard. Its basic query is select count(distinct(MerchantId)) as mcount from MerchantActivity, which returns the number of merchants displayed on the map (currently 423). The underlying code is:

<div style="padding: 5px; font-weight: 100; font-size: 1.5em">Latest event count for 
{{ mcount }} merchants (map and scatter plot)</div>

See Value (text label) for more information.