Getting Summary row where the table has dynamic columns

[Sivaram]

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

[AbbeyHernandez]

@Sivaram

en added has no summed up values on the dynamic columns

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

[Sivaram]

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

[AbbeyHernandez]

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!

[Sivaram]

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.

[Tj340]

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

[AbbeyHernandez]

Thanks @Tj340,

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

[tristdrum]

Another +1 here!

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

---

I've also just realised that there is actually a BUG with using the Summary row with dynamic columns...I can't select the type of summary I want! (cc @AbbeyHernandez, can you recreate?)

Clicking on any of the options yields no change in selection (it's stuck on "None") for all the dynamic columns.

---

This is also ESSENTIAL for totals that update when filtering (if you do it in JS, we can't update the Summary row based on the search term or filters)

[tristdrum]

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

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.

[tristdrum]

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

---

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

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