Anonymous's avatar
Anonymous
Not applicable
5 years ago
Status:
New

When filtering visualization by item in another the data is incomplete but total correct

Hi,

Anybody had such situation? What can be the reason that I don't see all items  in the table even though total is correct.

I have 3 tables related both sides by Account ID and one calendar table connected to the pivotal table (one of the three).

when clicking on May 2021 I should see # of QI across different Account Types in the other table but somehow this is missing even though I see correct total. May is problematic one, rest works fine. 

 

 

Reports

3 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    The problem was in a relationships set up. QIs= quality interactions. Can someone explain?

    [dates]1->*[QI]1<-QI ID->*[QI Participants Match]*<-Account ID->1[Account]    causes an issue

    and

    [dates]1->*[QI]*<-Account ID->1[Account]1<-Account ID->*[QI Participants Match]    does not

     

     

     

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Anonymous 

     

    You may try adding calculated table to view intermediate calculation.

Completed Ideas