Forum Discussion

SoufTC's avatar
SoufTC
Icon for Helper I rankHelper I
5 years ago

Count records using filter related tables

Hi everyone, I'm trying to build a dashboard that contains a date page filter and that calculates the number of reports per user and also per day worked. Here is the schema of my tables:   ...
Need Help
Tutorial Requests
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

SoufTC 

The problem is filters on the date table flow down to the AGENDA_USER table but do not flow up to the USER table.  If you set the highlighted relationship to be bi-directional (filter in both directions) it should work.

 

  • SoufTC's avatar
    SoufTC
    Icon for Helper I rankHelper I
    5 years ago

    Hi jdbuchanan71 thank you for your answer i tried it but it still doesn't work !