Is there a way to filter using Choice component?

Ask for Help
1

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
Screenshot 2024-09-13 at 4.45.46 PM984×730 46 KB

2

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.

3

Here’s a tutorial I did a while ago that might inspire a solution:

1 Like
4

Another great example is shown by @Darren_Murphy in his video here:

2 Likes