Forum Discussion

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
2 years ago
Solved

How to get all data on chart

Hello.  I have 2 tables. A Tickets Table and a Data Table.    Date Table is related to the Tickets Table via a 1:M relationship with Date (From Date Table) and opened_at (From All Tickets Table) ...
Need Help
  • PPStar's avatar
    PPStar
    2 years ago

    I have been playing around, and i thnk my measures were wrong. 

    I fixed the measures and it appears to be working ok now. 

     

     

Slim-'s avatar
Slim-
Frequent Visitor
2 years ago

Hi,

 

Problem is coming from relation : the relation is between the opening date and the calendar table date.

Therefore when you use the calendar table date on x axis, the data is shown for the calendar table date -> opening date.

 

To counter this, keep your relationship between opened_at and your calendar table but also create another relationship between closed_at and the date from your calendar table. This second relationship won't be active since you can only have one relationship active : you can now create a measure using the function "CALCULATE" with "USERELATIONSHIP" that will override the relationship active to use the one you specify.

 

Regards

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
2 years ago

Thank you very much. I will try this shortly.