Forum Discussion
Drill Through Using Active or Inactive Relationship
Anonymous , in the drill-down report, use a measure or measures that are using a join with resolve date. then you will get that
amitchandak - Thank you. I have tried that this morning - it does work for resolved tickets, but then the breakdown for Created tickets then doesn't work properly! 😁 It's like if one works, the other doesn't!
If I drill through from Table 1 (Created tickets), I want it to use the Active join on Created Date, but If I drill through from Table 2 (Resolved tickets), I want it to use the Inactive join on Resolved Date.
Is that possible to do with just one drill-through page?
The only way I can see this being possible so far is to duplicate the dataset, have two active joins (one from each dataset), then have 2 separate drill-through pages, with one using dataset1 and the other using dataset2. I just feel like it will be a pain further down the line in a year or so!
Hope this makes sense!
Hi Anonymous
Have you solved your problem? If yes, kindly accept it as the solution. Otherwise, please provide more details about your problem so that we can work on it further. Thanks😃
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
