Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a *single* report that lists new & updated answers, with roll-up

edited Jan 5, 2021 11:59PM in Reporting & Analytics for B2C Service 4 comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!