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 support [grafica]

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 chart based on the newly queried value. Hope it helps.

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 create a column within the Glide data tab as a date column, but make it user specific so this works for multiple people. Set your date picker to fill this date column. Now create a relation column that will link the date in this sheet to the date in your chart data sheet. The relation is what you will use for your chart component. This will allow you to select any date and the relation will pull back any chart values the match that date. This will work instantly without any lag.

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 :slight_smile: **dates started on 4/22/20 Many thanks for your help!!!

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-measurement values I am new to glide. Could you please provide me some hint and also, clarify, how did you managed to get the value of the date picker as the filter condition of the data? Thank you

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. [image] How to change the data of a chart according to the selected date? 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 slight_smile **dates started on 4/22/20 Many thanks for your help!!!

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 process to put that value there.That, on the one hand. I woud actually need to pass to the Query two parameters: date from the date pick up, and user (which is the user´s email). Best regards

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 the chart data sheet, you should have a similar template of email and date. Then you can use the relation you created for the source of the chart.

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

Ask for Help

Jeff_Hager May 16, 2020, 6:05pm 20

Topic		Replies	Views
Need help on filtering charts based on date Ask for Help	4	594	July 15, 2023
Need Help on Dynamic Time Filtering with Choice Component for the Chart Ask for Help	6	330	July 14, 2023
Charts with Choice Component Ask for Help	5	571	February 3, 2021
Bar Charts change based on in app selection Ask for Help	4	377	August 25, 2020
Visualize data with the redesigned Charts component Archived Announcements layout , community-update , charts	55	1403	May 28, 2025

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

Related topics