Getting Summary row where the table has dynamic columns

App Building
1

I have a retool new table which populates data from a query whose columns will vary based on the query results. I have used Dynamic Columns and the outcome is perfect. However,

  1. When downloading (as CSV) the headers are missing
  2. Summary rows when added has no summed up values on the dynamic columns
  3. Is there a way to get sum of row values by adding a additional fixed column
    Thanks
2 Likes
2

Hey @Sivaram, great questions!

In response to your questions:

  1. This is a known issue on our end that we have a bug report for. We don't have any expected timeline at the moment, but I went ahead and linked the report to this thread so that if there are any updates we can let you know!
  2. Yes, Retool's table component has a Summary Row feature that you can read in more detail about on this post.
    Screen Shot 2023-09-11 at 1.43.53 PM
    Screen Shot 2023-09-11 at 1.43.53 PM1060×1454 122 KB
  3. There are a few different ways to go about this depending on what you're trying to achieve. Read here for details on a few different approaches.

Happy to answer any follow up questions, thanks! :slight_smile:

3

On point-2, the fact is, when using dynamic columns and summary row, it doesn't work. In fact it has not even aggregation defined

4

Thanks, Sivaram. I just made a request for this feature and will let you know of any updates!

I'm not sure what your use-case is, but it might be worth mentioning that if a column appears in two tables, you can opt out of listing it dynamically. In that case, one would be able to have a summary row for that particular column. Hope that helps!

5

Thanks for making the request.
As mentioned in my request, the use-case is : Table which populates data from a query whose columns will vary (for each run) based on the query results. Hence, it will have to be dynamic.

1 Like
6

I, too, have a use case for having summary rows (plural) for some data.

My data looks like this:

Category Sub-category Y-1 Q1 Y-1 Q2 Y-1 Q3 ... Y-n Qm
cat 1 sub 1-1 10 20 30 ... 60
cat 1 sub 1-2 10 20 30 ... 60
cat 1 sub 1-3 10 20 30 ... 60
cat 2 sub 2-1 100 200 300 ... 600
cat 2 sub 2-2 100 200 300 ... 600
cat 2 sub 2-3 100 200 300 ... 600
cat 2 sub 2-4 100 200 300 ... 600

In this table, the columns are dynamic. We need to fetch data that falls into whatever date range the user specifies, then display them by year and quarter. This could be 1 quarter, or many quarters across many years.

Each row belongs to category. I want it such that when I group the rows by category and hide the details (i.e. sub-categories), I want the table to look like the following:

Category Sub-category Y-1 Q1 Y-1 Q2 Y-1 Q3 ... Y-n Qm
cat 1 30 60 90 ... 180
cat 2 400 800 1200 ... 2400
1 Like
7

Thanks @Tj340,

I'll log a +1 and your use case!

8

Another +1 here!

I have dynamic columns that ALL need a SUM summary row!

9

@Van show some support here, I know you'll need it! :joy:

The workaround of 'calculate your own summary row in JS' isn't cool because then the row doesn't freeze, and you'll then have 2 summary rows if you want to use the built in feature.

10

Here's my use case (where each site column is dynamic). Excuse the poor quality testing data.

Screenshot 2024-07-26 at 16.38.00
Screenshot 2024-07-26 at 16.38.002634×1426 282 KB

In terms of how to configure this, option 1 in my opinion is to add in a 'Dynamic columns' option here.

Screenshot 2024-07-26 at 16.41.29

Option 2 could be to add a Summary Row section into the Dynamic Columns settings pane (below or within column properties?)

Screenshot 2024-07-26 at 16.42.40
Screenshot 2024-07-26 at 16.42.401256×1008 76.9 KB