# Chart - Sort by most recent date **URL:** \ **Category:** Ask for Help\ **Created:** [February 5, 2025, 9:34pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823 "2025-02-05T21:34:47Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Morgan\_Diesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morgan_diesen/32/83558_2.png) [@Morgan\_Diesen](https://community.glideapps.com/u/Morgan_Diesen)\ **Post date:** [February 5, 2025, 9:34pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/1 "2025-02-05T21:34:47Z")
I have a chart that I need to start at the most recent date. Right now it is showing the oldest date and you have to click through all the pages to get to the most recent. How can I add “sort order” in the options of the graph like in the “Business Report” Template. Screenshots below ![Screenshot 2025-02-05 143419](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16eb3a1be56f2841154f481bb17defddd97fb660.png) ![Screenshot 2025-02-05 142936](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/75fb2687e68f171553dda0809339bf728081134c.jpeg) ![Screenshot 2025-02-05 143344](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/bec3c68a65ce1d092e48c19ed4fb475265d41a16.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 6, 2025, 1:19am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/2 "2025-02-06T01:19:26Z")
You can use a query column to query the data you need, and do the sort in that column. Use that column as the data source for your chart. Also, you probably want to increase the “page size” to show more dates? ---
**Author:** ![Morgan\_Diesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morgan_diesen/32/83558_2.png) [@Morgan\_Diesen](https://community.glideapps.com/u/Morgan_Diesen)\ **Post date:** [February 6, 2025, 2:33am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/3 "2025-02-06T02:33:53Z")
Sorry im confused. You cant choose a column as a data source for a chart it has to be a sheet. As far as the page size we want to show last 7 days which is how it is set right now. I created a query column in the table and queried the “periodstart” date but still dont have an option to sort the chart by the date. ![Screenshot 2025-02-05 193446](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b380554bded68666319329bcb50cb1ef186b57c3.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 6, 2025, 2:53am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/4 "2025-02-06T02:53:27Z")
> [@Morgan\_Diesen](#): > > Sorry im confused. You cant choose a column as a data source for a chart it has to be a sheet. It can be a query, that’s what I was trying to write above. > [@Morgan\_Diesen](#): > > I created a query column in the table and queried the “periodstart” date but still dont have an option to sort the chart by the date. You do the sort in the query column, not the chart. ---
**Author:** ![Morgan\_Diesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morgan_diesen/32/83558_2.png) [@Morgan\_Diesen](https://community.glideapps.com/u/Morgan_Diesen)\ **Post date:** [February 6, 2025, 3:44am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/5 "2025-02-06T03:44:55Z")
hmm I cant choose the query column as a source for the chart. What am I doing wrong here? ![Screenshot 2025-02-05 204429](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56b39e00a287005e60949921ae0d47bfcbe75512.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 6, 2025, 4:02am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/6 "2025-02-06T04:02:35Z")
![CleanShot 2025-02-06 at 11.02.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a5b2dd2176dcb5d07448d90de90efcf92d970b38.png) I think you should change it in this part. ---
**Author:** ![Morgan\_Diesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morgan_diesen/32/83558_2.png) [@Morgan\_Diesen](https://community.glideapps.com/u/Morgan_Diesen)\ **Post date:** [February 6, 2025, 7:14pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/7 "2025-02-06T19:14:29Z")
Thats what im confused by. I cant select a column for a data source only a sheet. This is pulling data for “ApData”. I added a query column in the ApData source but I cant select that column as the chart data source ![Screenshot 2025-02-06 121416](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e9acbc2c365807e1ca9df52c45e5d251217d45b.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 6, 2025, 7:21pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/8 "2025-02-06T19:21:17Z")
Is your query column in the same table that is the source of your screen? ---
**Author:** ![Morgan\_Diesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morgan_diesen/32/83558_2.png) [@Morgan\_Diesen](https://community.glideapps.com/u/Morgan_Diesen)\ **Post date:** [February 6, 2025, 7:27pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/9 "2025-02-06T19:27:10Z")
Yes it is. Shown in attached screenshot. White block is sensitive info I have covered up ![Screenshot 2025-02-06 122553](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8bd1c422114bb542994e00c10a7cab9e22428583.png) ---
**Author:** ![Morgan\_Diesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morgan_diesen/32/83558_2.png) [@Morgan\_Diesen](https://community.glideapps.com/u/Morgan_Diesen)\ **Post date:** [February 6, 2025, 8:00pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/10 "2025-02-06T20:00:00Z")
Okay, that was my mistake I found where I can select a query column as a "Data Source’ for the chart. I select that query column and change sor to “Z-A” but it still doesnt change the graph ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 6, 2025, 11:36pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/11 "2025-02-06T23:36:41Z")
> [@Morgan\_Diesen](#): > > I select that query column and change sor to “Z-A” but it still doesnt change the graph I believe the suggestion was to apply the sort inside the query, not on the chart. Like below: ![CleanShot 2025-02-07 at 07.02.04@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1bfe00e89cca0b85158bc1c0e5d0fa900a257cd8.png) ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 8, 2025, 1:45am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/12 "2025-02-08T01:45:26Z")
I checked with Morgan. We tested that out with a simple collection using the query as the source. It was indeed showing the right sorting. But the chart doesn’t want to respect that sorting. Note: He is using Postgres. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 8, 2025, 2:58am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/13 "2025-02-08T02:58:59Z")
Should be reported as a bug in that case. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 8, 2025, 3:40am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/14 "2025-02-08T03:40:22Z")
Can you escalate it? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 8, 2025, 3:42am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/15 "2025-02-08T03:42:02Z")
[@glide\_help](https://community.glideapps.com/groups/glide_help) Please check this thread. @Morgan_Diesen @MaximeBaker Please feel free to give more context to this issue if needed here. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 8, 2025, 3:44am UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/16 "2025-02-08T03:44:54Z")
Thanks ! The chart seems to do bad behaviour with external sources. MySQL had the issue with precision after comma too. That was reported by @Morgan_Diesen to the support team. We could probably try to replicate this with standard Glide tables to see if it is only a postgres issue. ---
**Author:** ![comm\_support\_agent](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/comm_support_agent/32/84195_2.png) [@comm\_support\_agent](https://community.glideapps.com/u/comm_support_agent)\ **Post date:** [February 13, 2025, 8:23pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/17 "2025-02-13T20:23:59Z")
I took a look at this issue and found that the sorting behavior (when using high-scale data sources for Charts) doesn’t seem to be supported at this time. I’ve reached out to the team for confirmation, but my testing has produced inconsistent results that make me think that the “Sort” option is missing from the Chart’s options section by design and the work-around to use a Query column as the Chart’s source won’t work reliably (even though the Query column looks to provide the sorting option, the Chart itself doesn’t seem to respect it). I will touch base once I hear from the team to confirm these assumptions. Note that this only applies to high-scale data sources like Glide Big Tables, SQL, etc. ---
**Author:** ![Jordannn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jordannn/32/62728_2.png) [@Jordannn](https://community.glideapps.com/u/Jordannn)\ **Post date:** [February 24, 2025, 7:05pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/18 "2025-02-24T19:05:40Z")
+1 : I just ran into this issue independently. Just trying to sort a bar chart by date ascending with a Postgres data source and can’t do it (the option to apply a sort in chart options is not shown). Tried pulling data with a custom query with date sort on the table but that didn’t work either. Without this my chart is unusable. Hoping for a resolution 🙂 ---
**Author:** ![comm\_support\_agent](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/comm_support_agent/32/84195_2.png) [@comm\_support\_agent](https://community.glideapps.com/u/comm_support_agent)\ **Post date:** [February 24, 2025, 7:46pm UTC](https://community.glideapps.com/t/chart-sort-by-most-recent-date/79823/19 "2025-02-24T19:46:59Z")
I can confirm that this is a current limitation of the existing Chart component when using a high-scale data source (like Glide Big Tables or SQL, for example). The team is working on a solution to the underlying limitation, but I don’t have an ETA at this time.