# Big Tables and computing values **URL:** \ **Category:** Ask for Help\ **Created:** [July 10, 2024, 4:43pm UTC](https://community.glideapps.com/t/big-tables-and-computing-values/74791 "2024-07-10T16:43:21Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Andrew\_Dunlap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_dunlap/32/61299_2.png) [@Andrew\_Dunlap](https://community.glideapps.com/u/Andrew_Dunlap)\ **Post date:** [July 10, 2024, 4:43pm UTC](https://community.glideapps.com/t/big-tables-and-computing-values/74791/1 "2024-07-10T16:43:21Z")
Hi Folks! I need to aggregate sales records returned in a big table query by MMM y to display in a chart as the X axis. All my fields that computed this before aren’t available through big table charting as an X axis though ☹ . How are people solving things like this to chart data in big queries and not have every date be in the x axis? Thanks! ---
**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:** [July 10, 2024, 11:27pm UTC](https://community.glideapps.com/t/big-tables-and-computing-values/74791/2 "2024-07-10T23:27:22Z")
I wonder if you use Quickchart or Chart.js with Big Table computed data, would it work? > [@heart\_eyes Quickchart.io: the Cloudinary of Charts —on the fly charts!](https://community.glideapps.com/t/quickchart-io-the-cloudinary-of-charts-on-the-fly-charts/15946): > > GAME CHANGER! Stumbled upon this site today—a way to create on the fly charts using data from your Glide tables. Images render instantly and you can select one of 14 different charts, customize colors, styles etc all through URL parameters! The video below shows my first attempt to create a chart from scratch and implement it in Glide. Took me less than 5 minutes. End result: [Direct Loom link](https://www.loom.com/share/8a4a2fffcef946a288b5ad53560bc469?sid=9b1e0895-9489-43bb-bab6-97a6e6de45c4) ---
**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\ **Post date:** [July 11, 2024, 5:43pm UTC](https://community.glideapps.com/t/big-tables-and-computing-values/74791/3 "2024-07-11T17:43:33Z")
If the records are being created in Glide you could use a set column action on creation that writes the results of a Format Date column to a text column. Of course, that doesn’t help with any records that are imported as it requires an action (button press) per row. You could also use a Zapier or Make action to format the date and write it back to that text column. But to do this as a batch you would need to use the Advanced Glide API and set it to run at intervals. ---
**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\ **Post date:** [July 11, 2024, 5:57pm UTC](https://community.glideapps.com/t/big-tables-and-computing-values/74791/4 "2024-07-11T17:57:44Z")
BTW, Glide Workflows is in the works and you may be able to use as a solution for this…but we won’t know for sure until we see what features are coming initially. 🙂