# How to filter and group data in a graph based on a helper table

**URL:** <https://community.glideapps.com/t/how-to-filter-and-group-data-in-a-graph-based-on-a-helper-table/77397>\
**Category:** Ask for Help\
**Created:** [October 28, 2024, 9:12am UTC](https://community.glideapps.com/t/how-to-filter-and-group-data-in-a-graph-based-on-a-helper-table/77397 "2024-10-28T09:12:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rajiv\_Singh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rajiv_singh/32/81194_2.png) [@Rajiv\_Singh](https://community.glideapps.com/u/Rajiv_Singh)\
**Post date:** [October 28, 2024, 9:12am UTC](https://community.glideapps.com/t/how-to-filter-and-group-data-in-a-graph-based-on-a-helper-table/77397/1 "2024-10-28T09:12:00Z")

</div>

Hi, I’ve built a timeframe filter based on Robert Petitto’s video here [Glide: Dynamically Filter your Data by TIMEFRAMES (Part 1)](https://www.youtube.com/watch?v=pApLeMYHFzE)

Pretty much followed exactly as per the video. Now I want to add a Bar chart that groups and displays a COUNT of the records by Day, Week and Month in the graph. Kinda stuck here, not sure how to build this logic in the helper table?

---

<div class="post-metadata">

**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:** [October 28, 2024, 3:46pm UTC](https://community.glideapps.com/t/how-to-filter-and-group-data-in-a-graph-based-on-a-helper-table/77397/2 "2024-10-28T15:46:32Z")

</div>

take a look at @Darren_Murphy 's video here… priceless stuff.

> [@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…