# Big Table Rollups/Queries/Relations

**URL:** <https://community.glideapps.com/t/big-table-rollups-queries-relations/68380>\
**Category:** Ask for Help\
**Created:** [December 5, 2023, 12:51pm UTC](https://community.glideapps.com/t/big-table-rollups-queries-relations/68380 "2023-12-05T12:51:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chase3](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chase3/32/62088_2.png) [@Chase3](https://community.glideapps.com/u/Chase3)\
**Post date:** [December 5, 2023, 12:51pm UTC](https://community.glideapps.com/t/big-table-rollups-queries-relations/68380/1 "2023-12-05T12:51:42Z")

</div>

Hi there,

I’m working on a dashboard where there are three main databases: clients, pages, and clicks.

Each time a page is visited, a click is registered and added to the click table. The table has the page ID as well as the time it was accessed.

For the pages database, each page has a page ID, the client name, and some other misc. information about the page.

The client database has a record for each client and a relation to the pages that belong to that client.

I’m trying to display KPIs on a dashboard such as Todays clicks, clicks over the past 7 days, clicks over the past 30 days, and lifetime clicks. I want the client to be able to see these for their organization but also be able to click on a individual page and see those same metrics for an individual page.

Where I’m running into a roadblock is I can get that data to work/rollup for each page but I can’t find a way to calculate those numbers for the client as a whole. Meaning, with the big tables, I can use queries/relations/rollups to calculate the KPIs for the individual pages but when I go to do the same for the client based on the relations to the pages, I can’t do a rollup as that’s not allowed with Big Tables. What are some ways to work around this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 5, 2023, 1:52pm UTC](https://community.glideapps.com/t/big-table-rollups-queries-relations/68380/2 "2023-12-05T13:52:38Z")

</div>

> [@Chase3](#):
>
> I can use queries/relations/rollups to calculate the KPIs for the individual pages but when I go to do the same for the client based on the relations to the pages, I can’t do a rollup as that’s not allowed with Big Tables. What are some ways to work around this?

Take a Joined List of the values that need to be summed, via the query/relation (this is supported), and then pass the list to a JavaScript column. Use JavaScript to process the list and output the calculated sum.