Forum Discussion

sea's avatar
sea
Frequent Visitor
8 years ago

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...
Need Help
ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi sea,

 

This filter doesn't affect the target table because the relationship is just on "id_user".

When you select a year on "Activities" table it simple gets all rows from Target table (or filtering by users).

 

Do you wanna compare the target per day of activities ? If yes, you can use the append function on those 2 tables.

 

Let me know if I can help you.

 

Thanks, 

 

Ricardo

sea's avatar
sea
Frequent Visitor
8 years ago

I want to see the target and the activities for the selected year.

  • ricardocamargos's avatar
    ricardocamargos
    Continued Contributor
    8 years ago

    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