How to get a dynamic count when applying 2 filters to the same list?

Ask for Help
1

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.

Is there a dynamic way to do this?

My Type Filters

image
image458×908 28.5 KB

My Style Filters

image
image456×893 33 KB

With 2 filters applied, the result should be 1, and I want the filters to dynamically update to show the correct amount of results available in the dropdowns.

image
image447×891 99.5 KB

2

I’ve recently done this with multiple filters (4, in my case).
Here is the technique that I used (applied to your example):

  • Create user specific columns for each choice component (Type, Style)
  • Create a template column that concatenates these two columns
  • Create another template column that concatenates those same two attributes (Type, Style) in your data
  • Create a multi-relation between those two columns
  • Make that multi-relation the source of your inline list
  • To get the dynamic count, add a rollup using the same multi-relation column

Here is a short video that shows how that works (notice how the total - shown in the hint component - updates dynamically with each selection change).

1 Like
3

awesome! will try this out!

4

@Darren_Murphy
Hi Darren! May I ask.

If I have 6 choice components and select for example only 2 out of 6 it wont show the amount of items selected by 2 choices. It needs all 6 choices to be selected.
How to handle this issue?

5

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 :wink:

For an alternative approach that still uses dynamic relations, you can refer to this method by @gvalero

4 Likes
6

Thank you Darren for your help again!

7

A take on the method @Darren_Murphy is describing can be seen here:

2 Likes
8

Thank you Robert!