# Glide Big Table

Hello,
It is possible to make a monthly report with Glide Big Table?
Something like
[Financial data - #4 by nathanaelb]

Itâ€™s possible, but can be a bit tricky. For example, the relation that @nathanaelb describes will not work with a Big Table, because relations that target computed columns are not supported.

So you need to adopt other methods. It depends exactly what you need. Charts work quite well with Big Tables, so if all you need is a chart Iâ€™d say just give it a go and then ask for help if/when you get stuck.

If you need something else, give us a clear description of what it is and weâ€™ll do our best to help.

1 Like

Well,
I have a database where drivers enter their car journeys.
I want to make a report per month, more precisely how many registrations are made each month for all drivers. Then when you click on each month, the date and the races for each individual car will appear.

So in your current Big Table, youâ€™re storing the journeys with a date that the user can enter, in a basic column?

1 Like

Yes, it is a date & time column.

@Darren_Murphy is the fix for computed columns Mark mentioned the other day live for Big Tables?

That one was just an enhancement to allow rollups of math columns in GBT.
I believe that Mark is actively working on removing GBT limitations, so we can probably expect to see these enhancements start to drop on a regular basis.

2 Likes

For your case, I think as the date is static, you can:

• Add a math column to calculate the month numeric value (called â€śMonth numericâ€ť) of the journey record: YEAR(D)*10^2+MONTH(D) with D being the recordâ€™s date.

• Add a basic number column named â€śMonth basicâ€ť.

• Use an on-submit action to set the value of â€śMonth numericâ€ť to â€śMonth basicâ€ť.

• Create a table of months, with a â€śMonth numericâ€ť column having the same formula as stated above.

• Create a relation from this table to your journeys table, using the â€śMonth Numericâ€ť column in â€śMonthsâ€ť to relate to â€śMonth basicâ€ť in journeys.

• Create a rollup column to count the number of registrations and show a collection based on the relation in the details view of each month.

1 Like

Thank you!! It worked!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.