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

**URL:** <https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789>\
**Category:** Ask for Help\
**Created:** [April 25, 2020, 1:59am UTC](https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789 "2020-04-25T01:59:20Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![Juan\_Gutierrez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan_gutierrez/32/692_2.png) [@Juan\_Gutierrez](https://community.glideapps.com/u/Juan_Gutierrez)\
**Post date:** [May 4, 2020, 1:04am UTC](https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789/8 "2020-05-04T01:04:02Z")

</div>

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](http://fyuql.glideapp.io)

Its a little slow but works 🙂

\*\*dates started on 4/22/20

Many thanks for your help!!!

---

_[View the full topic](https://community.glideapps.com/t/how-to-change-the-data-of-a-chart-according-to-the-selected-date/7789)._