I have information that is classified by date and I want to present the data according to it in a graph to represent the history to the selected day. How can I control that? When I put the component to select a date, doesn’t it link it to the table where the data is? Thank you very much for your su…

I think you can use a QUERY to achieve that. Have not used a Date component in my apps, do that store a value in the sheet? If yes, you can probably do something like: QUERY(your original full data, “SELECT * WHERE DateCol = '”&(Insert Cell Where Date component value is stored)&"’,-1) Then get the…

You should be able to do this with a relation. Create a sheet that will contain a description column or anything you want really. Doesn’t matter. That new sheet will also become your tab displayed in the detail style view. You can also create a date column in the sheet, but preferably you would …

If you have any problems with it feel free to contact me via this thread or at: ariesarsenal@gmail.com .

I already found the solution for this problem and was using this SQL sentence =“Select C ,B, E,sum(E) WHERE C = date '”&text(K4,“yyyy-mm-dd”)&"’ group by C,E, B" I made this example so you can see how it works this is the link Change chart according the selected day Its a little slow but works …

Hola Juan, Thanks for sharing your app. I am trying to build up an app that would store user´s health self-measurement. I am struggling with replacing the data picker in your app by a choice component. With that choice component the user can select only dates for which he or she has submitted self…

Hi Antonio, firstly welcome to Glide! Can you share with us some screenshots about your problem, and your current settings for the app? As for the last question, I would think that the date picker’s value goes to a certain cell in his sheet, then it will be passed on to the QUERY presented here. …

Hi ThinkDinh. Thanks for the welcome and reviewing my question. Please, have a look at the screendhots at this link https://share.getcloudapp.com/collections/gKfJ3d/Glide-apps-community Indeed, the date picker´s value goes to a certain cell in his sheet. Unfortunately, I can´t figure out the proc…

I might need to see more of how your data is structured and how to dates are stored, but you should be able to select a date from a choice component, then create a template that joins the user’s email and the selected date, the create a relation to the sheet that contains the data for the chart. In…

How to change the data of a chart according to the selected date?

Ask for Help

Antonio_Marin May 14, 2020, 3:38pm 14

It would be straightforward to have a method to use the chosen date as a parameter for the chart filter. Obviously, that is not the way glide works.

Topic		Replies	Views
Need help on filtering charts based on date Ask for Help	5	557	July 15, 2023
Need Help on Dynamic Time Filtering with Choice Component for the Chart Ask for Help	6	293	July 14, 2023
Charts with Choice Component Ask for Help	5	544	February 3, 2021
Bar Charts change based on in app selection Ask for Help	4	348	August 25, 2020
Visualize data with the redesigned Charts component Archived Announcements layout , community-update , charts	56	1110	June 4, 2025

How to change the data of a chart according to the selected date?

Related topics