# Is there a way to filter using Choice component? **URL:** \ **Category:** Ask for Help\ **Created:** [September 13, 2024, 8:54pm UTC](https://community.glideapps.com/t/is-there-a-way-to-filter-using-choice-component/76364 "2024-09-13T20:54:42Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Todd\_Hinson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_hinson/32/79081_2.png) [@Todd\_Hinson](https://community.glideapps.com/u/Todd_Hinson)\ **Post date:** [September 13, 2024, 8:54pm UTC](https://community.glideapps.com/t/is-there-a-way-to-filter-using-choice-component/76364/1 "2024-09-13T20:54:42Z")
Hello Everyone, Apologize in advanced if this is a silly question - extremely new to Glide. I am trying to build a KPI dashboard that will show/filter financial data based on the choices a user makes. 1. the user chooses if they want to see monthly, quarterly, or yearly data and then based on the choice in the “View” Choice component, the components of the “Time period” choice component change. 2. then, based on the choice in the “time period” component, all the components below (big numbers, bar charts) update to reflect the choice. is this possible? I’ve attached a screenshot for reference. ![Screenshot 2024-09-13 at 4.45.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4bbb2a164438f9e34fe7be2a0b04e0c40839b1f8.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 14, 2024, 12:32am UTC](https://community.glideapps.com/t/is-there-a-way-to-filter-using-choice-component/76364/2 "2024-09-14T00:32:41Z")
Yes, that should be possible but it’s complex. You have to derive the starting and ending dates based on the user’s choice of time period and do calculations to get each of the numbers on the screen. Then, you have to calculate the “last period” as well to determine the increase/decrease in value. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 14, 2024, 2:42am UTC](https://community.glideapps.com/t/is-there-a-way-to-filter-using-choice-component/76364/3 "2024-09-14T02:42:33Z")
Here’s a tutorial I did a while ago that might inspire a solution: > [@🗓️ Dynamically filter an inline list by TIMEFRAME (Parts 1 & 2)!](https://community.glideapps.com/t/dynamically-filter-an-inline-list-by-timeframe-parts-1-2/42671): > > wave Hey fellow Gliders! In this video, learn how to dynamically filter a list of records by timeframes (day, week, month, etc.) using a Choice component, some Math columns and a Make Array column. Also features the concept of a “Work Table” to keep your data tables lean! popcorn Enjoy! Part 1 [[Glide: Dynamically Filter your Data by TIMEFRAMES (Part 1)] ](https://www.youtube.com/watch?v=pApLeMYHFzE)Part 2 [[Glide: Dynamically Filter your Data by DATE RANGE (Part 2)] ](https://www.youtube.com/watch?v=AVSavEhdt6Y) ---
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [September 14, 2024, 7:08am UTC](https://community.glideapps.com/t/is-there-a-way-to-filter-using-choice-component/76364/4 "2024-09-14T07:08:45Z")
Another great example is shown by @Darren_Murphy in his video here: > [@Searching everything from the home screen: tabs, collections or rows of data](https://community.glideapps.com/t/searching-everything-from-the-home-screen-tabs-collections-or-rows-of-data/72783/4): > > You could create you own custom search to do this. Something like this: Create a User Specific column to hold the search text. This should be in the table that your Home Screen is attached to. (Normally I’d say put that column in your User Profiles table, but I think your App doesn’t require sign in, yes?) In each of the tables that you want to search, add the following columns: – A single value column, that fetches the search term from the Home Screen table – Now, lets assume you have a Na…