Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Linked, lookup and rollup. Need some help sorting this out ;)

Topic Labels: Formulas
242 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Slowly I am getting a better understanding of Airtable :slightly_smiling_face:
I have a table called task:
Skjermbilde 2021-03-09 kl. 08.56.42
And a table for completed task:
Skjermbilde 2021-03-09 kl. 08.57.26
So far so good.
When a user completes a task, a new record of the task is created in “completed task” along with “device.id” to keep track of which user completed the task.

Then I have a table called “Stats by device”
Skjermbilde 2021-03-09 kl. 08.59.22

Where I get the:

• The sum of act/belong/commit score (by user)
• total completed task (by user)

And last, a table called “stats by task”
Skjermbilde 2021-03-09 kl. 09.31.24

Where I get:
• A global count on how many times a specific challenge has been completed.

What I would like to get, but don´t know how to:
• a count that shows how many times a specific challenge has been completed by a specific user (i.e. User A has completed challenge “kaste ball” 5 times)

I reckon that the answer to the question above will also give me the solution to the “top 5 challenge” stat - a list where you can see which 5 challenges has been completed by you the most times.

Regards,
Tor Martin

1 Reply 1

Just want to bump this is anyone has a tip to guide me on the right path to solving this :slightly_smiling_face: