Add a simple drilldown to cloud state blocks

Gists
,
1

I’ve been working on adding an easy way to drill down from a state block in SquaredUp Cloud to a separate dashboard, and after a couple revisions I think I’ve found a pretty easy way I wanted to share quick.

1. Get your state tiles created

This works with any data source or data stream, for the example I added an AWS data source and listed three of my lambda functions, but it will work with anything.

image
image3368×731 51 KB

2. Make dashboards with the same name as the tile, these can be in any workspace

image
image364×769 22.8 KB

3. Connect them with SQL Analytics

Enable SQL Analytics and in the second dataset pick the SquaredUp Data Source and the Properties Data Stream.

On the objects page select the Dashboard type and enable Dynamic selection to include all your dashboards. It should look similar to what I’ve got below.

image
image1876×810 93 KB

Now in SQL all you have to do is join the two tables on their name columns and then concatenate a new URL for your drilldown.

image
image1858×948 74.1 KB

If you’d like to use the names stateBlocks and dashboards for your two datasets the SQL script below should be almost ready to use

SELECT  stateBlocks.[data.name],
        [data.state],
        'https://app.squaredup.com/dashboard/' + ifNull(dashboards.sourceId,'') [drilldownLink]
FROM stateBlocks 
left join dashboards
on stateBlocks.[data.name] = dashboards.name
1 Like