Help

How to setup a stats table that pull the info from a master table

538 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jonjohnston3
4 - Data Explorer
4 - Data Explorer

Hello! I am attempting to recreate some data I have in Google Sheet and improve my work flow. I am currently counting things by hand and it taking to long. What I am trying to do is create a "Master" sheet where all my info lives. But have a "Stats" table that will then automatically aggregate the data by Photographer and month. It would count the specific "Production Type" and sort it by "Photographer" and month. I have attached some screen shots. I have been trying to google it for days with not luck. 

Here is the start to my "master" table

Screenshot 2024-01-09 at 3.53.53 PM.png

Here is my current "Stats" tables I have in Google Sheets:

By Month:Screenshot 2024-01-09 at 3.52.28 PM.png

It then feeds into a yearly data sheet

Screenshot 2024-01-09 at 3.52.51 PM.png

1 Reply 1
preshetin
6 - Interface Innovator
6 - Interface Innovator

Hi @jonjohnston3 - one way of making some stats aggregation could be via Interfaces. Here, you can build a dashboard on top of your Master table. This Interface may look like this:

preshetin_0-1704907022765.png

Hope this helps!