I need to create a webi report which shows the re-opened tickets with re-open timestamp and corresponding close timestamp.
I can fetch the data from activity log. If a ticket is re-opened multiple times, I can show all the re-open timestamp,but the only thing is, I need to show the corresponding close date as well. Right now, I can only show the final close date, not all the intermediate close dates.
How can I achieve that from activity log?