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,
When downloading (as CSV) the headers are missing
Summary rows when added has no summed up values on the dynamic columns
Is there a way to get sum of row values by adding a additional fixed column
Thanks
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!
Yes, Retool's table component has a Summary Row feature that you can read in more detail about on this post.
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!
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.