Forum Discussion
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) ...
I have been playing around, and i thnk my measures were wrong.
I fixed the measures and it appears to be working ok now.
Hi PPStar
This is about relation, you will have to create two relation from Date Table to Tickets Table.
When you create a relation then one will be active and another will be unactive. So, create active relation with opened_at and inactive relation with closed_at.
Once you are done with modelling part. Then create measure, for closed_at using "Calculate" and "Userelationship" to make it active.
Best Regards.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, i never knew this. I will try this shortly. Thanks again