Can/is a summary table row be removed if all its metrics are zero/null?

[ian.p]

If you have a summary table where a row that gets inserted changes over time in such a way that all of its metrics are back to zero or null, can/is that row removed so that you don’t have to filter it out in an interactive report?

For example, consider a summary table where the dimensions are COLOR and ANIMAL and the Metric is QUANTITY there is no pre-existing record for Black Cat. A new transaction results in there being a summary table record for 1 Qty Black Cat, which causes a summary table row for Black Cat to be inserted. But later, a subsequent transaction results in there being 0 Qty Black Cat and instead of having to filter for Qty <> 0, can/is that summary table row be removed so I don’t have to worry about it filtering it out when reporting on this?

CC: @claire.minnaar

[jeremy.keller]

We could take an enhancement request to look at adding this functionality, but right now there is no deletion of records once they enter the summary table. The records will just zero themselves out if all relevant transactions are removed from the summary table.

[claire.minnaar]

@jeremy.keller Just my two cents worth on this - I think it would be useful to have a feature to remove records under certain conditions from a summary table to keep things “clean”. Would probably help performance too. Thanks for the feedback!

Tagging @ian.p

[chris.walsh]

As Jeremy stated, we currently don’t support this capability. @claire.minnaar or @ian.p can you capture the use cases and enter an idea for future consideration and then forward to me?

Thanks!