Jump to content

Nested Summary Tables: One Table to Show Different Time Frames


Recommended Posts

  • Seeq Team

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

 Screen Shot 2021-09-01 at 3.17.00 PM.png

There are a couple ways to achieve this in Seeq. In this example, we'll explore using Simple Scorecard Metrics 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 Tables & Select Simple

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

Screen Shot 2021-09-02 at 8.35.56 AM.png

 

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.

Screen Shot 2021-09-02 at 8.41.55 AM.png

 

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.

Screen Shot 2021-09-02 at 8.45.07 AM.png

Screen Shot 2021-09-02 at 8.48.15 AM.png

After clicking the table & Update Seeq Content:

Screen Shot 2021-09-02 at 8.50.20 AM.png

 

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.

Screen Shot 2021-09-02 at 9.07.00 AM.png

 

Rename this column to 24 hr avg.

Screen Shot 2021-09-02 at 9.08.08 AM.png

 

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).

Screen Shot 2021-09-02 at 9.12.03 AM.png

 

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.

Screen Shot 2021-09-02 at 9.16.28 AM.png

Screen Shot 2021-09-02 at 9.19.24 AM.png

 

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...