How to display quarters when I have monthly plans?

Ask us anything How do I?
1

I have a monthly plan table in Xano.

image
image1054×590 42.7 KB

I want to a quarterly report which collates data from all 3 months in the quarter on a different page in Weweb.

What’s the most efficient way to do this? Do I need to create a whole new table for “Quarters”, even if the quarterly report has no new information, it is just data from the 3 monthly plans within the quarter?

Meaning I have to create a whole new “quarter report” everytime a monthly plan is created?

Or is there a faster way to query all the monthly data, turn them into an array of quarters automatically?

I hope this makes sense…

2

You can make a Xano function that just creates a quarterly report on the fly from the monthly data using Xano’s add-ons & sort functionality - but I would need to see see more specifically how the data is structured in Xano and how you want it to be structured in the quarterly report to give any detailed suggestions. But based on what you posted - I would not make another table.