How to create a *single* report that lists new & updated answers, with roll-up
Content
Brief background/context:
In our environment we have an annual review policy for all of our answers, which ensures that everything gets an 'eyeball' at least once per year, and also instills greater confidence in our customers that the content they're looking at isn't stale (e.g., "Last updated during the Ford Administration"). As often as not, some of these answers aren't having their content edited per se, they're merely moving from published -> expired -> approved -> published, with a new expiry date.
What we're trying to do:
Regardless, we want to make sure that staff are aware not only of new answers, but of answers that have been updated as well. I know that I can create a dashboard to distribute monthly and nest two different reports in it (one for new answers and one for updated answers), but I'm curious to know if it's possible to do this using one report, using some combination of transaction table fields, rollups and filters?