Conditional Rollup on Big Tables

Ask for Help
1

Hey guys,

I’m pulling data from another source via API and need to use Glide Big Tables for this application.

I am trying to figure out a way to create a conditional rollup based on date (week, month, cumulative).

I tried @Darren_Murphy’s year-month filtering solution, however, I realized that you can’t rollup computed fields in big tables.

If it helps, here is what the table looks like

image
image1697×437 123 KB

I have no problems rolling up the cumulative data, but I can’t figure out how to rollup only this week’s data or this month’s data with Big Table restrictions.

Any ideas?

2

What exact columns are you trying to rollup?

3

Emails sent per month, emails sent per week, emails replied this month, emails replied this week, reply rate this month, reply rate this week, etc.

4

We’re working on enabling rollups of computed columns for Big Tables now.

5 Likes
5

If it helps anyone I figured out a solution.

All of this data is being pulled via API so instead of calculating week end date/month end date in Glide, I am calculating these in my automation in N8N.

Then in the main table I am rolling up to (which is a regular Glide Table), I calculate week end date and month end date.

Then I do two queries, one for this month’s campaigns one for this week’s campaigns with the filter Week/Month End Date is on or after Week/Month End Date.

I can then do the rollup from the query, which acts as a conditional rollup.

Not sure if that made sense lol but the only solution I could figure out to get this to work.