Help

Calculate the number of records in which the status is changed in all the tables in various based in a day?

Topic Labels: Views
916 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jay_P
7 - App Architect
7 - App Architect

How do I achieve this metric/ analytics ?

1 Reply 1
Florian_Verdon2
7 - App Architect
7 - App Architect

Hello Jay,

I will split my answer in multiple points to make sure you understand each step and make sure it can be useful for other members later.

1) How to track field changes + change dates ?

This can be done by adding a “Last modified time” field.
These fields can be customized to only track specific fields changes. (as shown in the screenshot)

Capture d’écran 2020-10-04 à 10.53.35

2. Filter records based on a date

Screenshot at Oct 04 11-01-36

3. Count modified records from linked record (count tasks status changes today from the linked project

You have to create a “Rollup” field that will COUNTALL() the records in the linked table that meet certain conditions.

Let’s add a “Linked record” to our Tasks list (linked to a “Projects” table)
Capture d’écran 2020-10-04 à 11.03.31

Then, from the Project table grid, add the rollup field like this :
Capture d’écran 2020-10-04 à 11.05.44

4. Statistics across multiple bases

This can now be done using the Airtable Sync feature introduced recently , more information is available here https://support.airtable.com/hc/en-us/articles/360052521254-Airtable-Sync-Basic-setup

Do not hesitate if you need clarification on this process

Florian VERDONCK
Airtable Consultant