Dashboard with date filter (Choosing) updating the others view present in it

Respected Members,

Being from a non-programming background, I am trying to build an application to manage daily activities in my business. I want a dashboard whereby choosing timeline in terms of month, year, date range, etc, I can filter the data in the respective view present in the dashboard so that reporting can be done on a weekly, monthly, and yearly basis. I have a date column in all my sheets, requesting to please let me know how to go about it as using slices with row filter I can do it either for a week or last month or a year, etc but how to create a list to choose the timeline as per will.

1 Like

Welcome to the AppSheet community.

Please take a look at the below sample app. The sample app has filter based on text ( values) , you could use date based filters instead.

https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f

Also please refer to following various date related expressions / functions to get the desired dates

Also please refer following AppSheet references related post thread that could be handy from time to time

3 Likes

Dear Surutt,

Thank you for the response.
Sorry to bother but have tried reading all the updates related to it but was not able to understand. Your emphasis on the stated answer has helped me to reach further.
Thank you!

2 Likes

No problem. You are welcome. We all have initial learning curve on any new product or new system/subject .

AppSheet makes this learning curve much faster and one can build progressively complex apps within fairly short period of time. There are plenty of very useful references including help articles, sample apps, and the community posts.

Please feel free to post in community your queries. The community is also very helpful.

1 Like