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?