Forum Discussion
relationship table not work
Hello, I have these table: I have the following relationships between the tables: activities->id_user = users->id_user ----both target->id_user = users->id_user ----both I have th...
I want to see the target and the activities for the selected year.
sea,
You can append those 2 tables and either filter by the same data field or create a new date table.
I tried it here, when I select "2018" it gives me 210. I think it's correct once you have 3 users, right ?
About the activities, are u gonna count the numbers of dates ? If yes, you can count the number of dates where the column "target_activities" is blank after append those tables.
Tks,
Ricardo