Is there anyway to configure the big numbers to show on screen data after it is filtered? In example, the total unfiltered sales number is 14.5k and if I filter by product type pineapple, the sales count should be 2 and the sales total should be 2.5k.
You can use custom filters for anything, including values for big number components. Custom filters set a value in a table. From there you can create relations or queries, and rollups on top of those relations or queries to get your final numbers for the big number components.
I can’t think of any recent videos, but there several ways to do it. Start by writing those custom filter values to user specific columns in the table that is the source of your screen, or write then directly to the user profile row in the user table. Then take those values and build Query/Rollup Columns, or use single value columns to populate the custom filter values across all rows in your collection table and use an IF column to return certain values if they fit your filters, then Rollup the IF column. Lots of ways to get the same result.