# Creating Dashboards from "Trebuchet Method" column/row data **URL:** \ **Category:** Ask for Help\ **Created:** [July 17, 2024, 11:28pm UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983 "2024-07-17T23:28:19Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Alger\_Bradley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alger_bradley/32/63597_2.png) [@Alger\_Bradley](https://community.glideapps.com/u/Alger_Bradley)\ **Post date:** [July 17, 2024, 11:28pm UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983/1 "2024-07-17T23:28:19Z")
I’ve created a simple ordering application for a small beverage manufacturer using the most recent trebuchet method from Robert :[https://www.youtube.com/watch?v=1QbKTccN850](https://www.youtube.com/watch?v=1QbKTccN850). Works great… My question is what’s the best method to create a metrics dashboard based on sales and in particular, based on products sold since the product info is consolidated within a JSON list within a single cell unrelated to the products table. I’ve posted the Orders screen below for reference… appreciate the help ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6447c6b0472ca0f571b988de4be7f2abdc8e048.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:** [July 17, 2024, 11:50pm UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983/2 "2024-07-17T23:50:19Z")
So do you need justs the products sold, or do you have to group it by date? ---
**Author:** ![Alger\_Bradley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alger_bradley/32/63597_2.png) [@Alger\_Bradley](https://community.glideapps.com/u/Alger_Bradley)\ **Post date:** [July 17, 2024, 11:53pm UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983/3 "2024-07-17T23:53:04Z")
Ideally both as the dashboard would be setup with timeframe filters. The date would come from the timestamp column as I didn’t include it in the JSON. if it’s easier to include direclty in the JSOn, I can add it no issue ---
**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 18, 2024, 12:18am UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983/4 "2024-07-18T00:18:04Z")
My first thought is: - Keeping the timestamp out of the JSON. You just need to keep it on the Order level. - Create timeframe filters and use a query column to query the related orders. - Join the OrderItems into a JSON array and use JavaScript to sum the sales for all unique items. - Either transpose the resulting JSON into a helper table to feed Glide’s chart, or use Quickchart/Chart.js to deal with it. ---
**Author:** ![Alger\_Bradley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alger_bradley/32/63597_2.png) [@Alger\_Bradley](https://community.glideapps.com/u/Alger_Bradley)\ **Post date:** [July 18, 2024, 12:48am UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983/5 "2024-07-18T00:48:46Z")
2 follow up questions… and thanks for the much needed guidance. - Novice at this at best so recommended prompt I could in chatgpt to help create said JS? - how should I think about using this approach vs the more straight forward orders → orderitems with relations to accomplish the same thing? ---
**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 18, 2024, 1:12am UTC](https://community.glideapps.com/t/creating-dashboards-from-trebuchet-method-column-row-data/74983/6 "2024-07-18T01:12:28Z")
> [@Alger\_Bradley](#): > > how should I think about using this approach vs the more straight forward orders → orderitems with relations to accomplish the same thing? This will be much more straightforward to create a dashboard chart. Your approach saves rows, but it’s harder to aggregate data.