I have made a bar chart on my app that compare my business market size and share monthly. I am trying to make the bar chart to show different data based on the month by choosing in app (something like salesforce).
My purpose is to give my team that use the app freedom to see the monthly data by choosing the month in the app. Is there any way to do this?
Thank you for the quick reply @Jeff_Hager, on which sheet i should put the relation column, the user specific sheet or the chart data sheet?
Ideally you would have a separate sheet that you use for your tab. It could have a single column set in the google sheet so it’s recognized by glide. Maybe you could put a short text description in that column and display in in the app. In the glide data editor, you can then create a user specific column that will hold the choice component value. Then you can create the relation column that uses the user specific column value to link to the chart data. All of it on the user specific sheet.
Thank you jeff for the help, really appreciate it!