Table Summary Row

Is there a simple way to have the Summary Row of a table recalculate after a filter is applied? As it stands now, it does not.

It works for me when I apply a search to the new table component.... what are you trying to do?
Screenshots?


So here is the table showing the Summary Row filtered for Date = July 30, 2023. As you can see, the Sums don't add up correctly since the filter was applied.

How was the filter applied?
It's possible that it only works when you Group rows by and using Search as I have done.
I don't see where or how you are applying filters.


"Filter" is at the bottom right of the table.

How are you using Search?

So the "filters" I build and use are usually Query JSON with SQL so that the entire table reloads with new data for the very purpose of Summarizing data and showing data in Dashboard like pages. But this is for the Legacy table component.

I added Search above a NEW table component as a textInput field and then in the table set the Search value to {{textInput1.value}}
It works very well and will probably allow me to remove other "filters" I built.

Screenshot 2023-08-17 at 9.15.04 AM

Screenshot 2023-08-17 at 9.16.08 AM

I see. Yes, that will work. I just thought I may be missing something with the Summary Row.

1 Like

Hi there! Thanks for the solution, @ScottR! Our team also went ahead and made it so that the client side filter is taken into account for the summary row :slightly_smiling_face: The fix shipped to Cloud & will be available on-prem in a couple of weeks