Dear FM Forums Users
I’m looking for some assistance to filter records based on a 2 table relationship.
My solution has the following tables:
Users (contains fields - ID, Name, account creation date, etc)
Activities (contains fields - Activity ID, User ID, start date, start time, etc)
Real life example: Lets say i have 10'000 registered users in the Users table, with registration dates ranging from the 1st Jan 2018 to 11th May 2019.
I would like to know how many users in the registration timeframe above performed an activity from the 1st Oct 2018 onwards.
I assume I need to join the two tables via the common user id and then create 2 x global fields for the date ranges.
Any advice/help would be greatly appreciated.