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!