Forum Discussion

PierreCA's avatar
PierreCA
Icon for Resolver I rankResolver I
2 years ago
Solved

Report doesn't show all relations

Hello, 

Here I have a report showing 4 id when I should 24. 

Behind are two linked tables with a one to many relation. A company table and a Communication table. The link is based on the company id. Very simple and classic. There's no special filter applied. More than one communicatino may have happend the same day, but when I remove the date, I keep saying only 4 id instead of 24. 

 

Company table is linked to some other tables, but they are not used in this context. I try with a copy of it and get the same limited results. 

What's the cause of the problem behind?


Need Help
  • PierreCA's avatar
    PierreCA
    2 years ago

    Thank you VijayP , 

    I finally got it. Problem is related to other table links .  Thanks for your time. 

     

5 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    2 years ago

    PierreCA 

    If same id occurs on different dates, then based on date context it shows separately but when you remove the date context, it gets aggregated and that is why you see lesser rows

    • PierreCA's avatar
      PierreCA
      Icon for Resolver I rankResolver I
      2 years ago

      Hello VijayP ,

      The id whey see on the second picture is without date context. They are unique communication id. Why then, is it still limited to 4 id?

      And if there was a date context, I want to every date id and dates.  How can I do that?

    • PierreCA's avatar
      PierreCA
      Icon for Resolver I rankResolver I
      2 years ago

      Hi VijayP , 

      I post a simplified model. Hope it'll work. Other tables are attached to Communication, but for they are currently out of context. 

      In the model, Company  #1 has 3 communications on 2024-05-16. Each communication has its own ID.   The output I expect is the Communication ID followed by date. I should see 3 differents ID and 3 times the same date in the report. 

      And according that simplified model, I don't experience the problematic issue described earlier. I have the 3 distinc IDs end the 3 same dates for the company #1. 

       

      • PierreCA's avatar
        PierreCA
        Icon for Resolver I rankResolver I
        2 years ago

        Thank you VijayP , 

        I finally got it. Problem is related to other table links .  Thanks for your time.