Blocks visualization

Block states

Blocks visualizations are most useful when selecting a State column on the Mapping tab. This setting enables the blocks to change color depending on the state value, which can be rolled-up as a health state and used to trigger notifications.

However, you may find that many of your data streams don't have any state data built-in, meaning that your blocks won't have any way to use this feature out of the box and therefore only ever display gray and static.

Creating state columns

1. Follow the tile editor workflow as normal, selecting the Data Stream and Objects you want to visualize, and configuring any necessary Parameters,Shaping etc.
2. Toggle Enable SQL Analytics on the toolbar and select Continue.
3. Do the following in SQL analytics mode:
   1. On the Query tab under SQL, enter a query that uses a CASE statement to return a state value of Warning, Success or Error. The AS value for which you return this case is used as the State for the visualization settings.
      
      For example, in the following query a Warning state is returned for articles which haven't been updated in over 100 days, else the state is returned as Success:
      Copy

      SELECT 
          title, 
          _updatedAt, 
          CASE 
               WHEN DATEDIFF(day, _updatedAt, GETDATE()) BETWEEN 90 AND 127 THEN 'Warning'
               WHEN DATEDIFF(day, _updatedAt, GETDATE()) > 128 THEN 'Error' 
              ELSE 'Success'
          END AS State
      FROM dataset1
      ORDER BY _updatedAt DESC;

   2. Click Execute to run the query.
4. Do the following on the Visualization tab of the right-hand pane:
   1. Select the Blocks visualization.
   2. Select the State you created from the Mapping section of the Visualization tab. The blocks are updated to reflect the conditions you defined in the query.

5. Click Save to save the tile.

Blocks settings

Mapping

Layout

Options

Was this article helpful?