I have a list of videos that I would like to filter by two properties: Video Type + Video Style.
I’m able to filter the list by using the filter properties on the component, and I’m also able to calculate the amount of videos that match the types individually, but I’m stuck on how to get a dynamic total for the remaining filtered items that match the filter criteria when both filters are applied.
hmm, that post is quite old. Although the technique I described there could still be used, these days I’d probably recommend a slightly different approach that avoids complex relations.
With multiple choice components acting as filters, I’d be more likely to use the following approach:
Write each choice component to a user specific column
Use a series of single value columns to apply each choice selection to all rows in the table to be filtered
Build logic in that table using one or more if-then-else columns to apply the filtering choices to each row. The end goal with this would be to have a single boolean column that indicates whether or not each row should be filtered. (true = filtered, empty/false = not filtered)
Use the entire table in a single inline list component, filtering where the above column is not true
And to get a dynamic count of filtered records, just do a rollup on the entire table, counting where that if-then-else column is not true.
The only really tricky part with the above is the if-then-else logic. The approach with this will vary from use case to use case, and can get quite hairy as the number of filters increases. But I’ve yet to encounter a situation where it can’t be done
For an alternative approach that still uses dynamic relations, you can refer to this method by @gvalero