Nested Summary Tables: One Table to Show Different Time Frames

[Emilio Conde]

We often would like to summarize data in a table to reflect something similar to below:

 

There are a couple ways to achieve this in Seeq. In this example, we'll explore using Simple Table view to get this result. If you're interested instead in using Conditional Scorecard Metrics, I would take a look at this Seeq.org post! 

 

Step 1:

Goto Table view & Select Simple

Under Columns, ensure Average, Last Value, and Name are selected 

 

Step 2:

Rearrange & rename the Headers; Last can be moved to 2nd column and renamed to Current. Avg (now 3rd column) can be renamed to 1 hr avg.

 

Step 3:

Copy the link and paste it into an organizer topic. Create a new Date Range named 1 hr (with a duration of 1 hr) to assign to your table.

After clicking the table & Update Seeq Content:

 

Step 4: Can be done on the same worksheet, or a new worksheet. I will create a new worksheet.

Back to Simple table, remove the Name column so only Average is selected.

 

Rename this column to 24 hr avg.

 

Step 5:

Paste this worksheet into your organizer next to your other table. Create another Date Range named 24 hr (with a duration of 24 hr) to assign to this newly added table (similar to Step 3).

 

Step 6: 

Click each table to then click the Toggle Margin button. When complete, the table should look like one single table. To update the date range for the entire table, simply click the "Step to current time signal" next to Fixed Date Ranges.

 

 

 

Edited January 14, 2022 by Emilio Conde