I'm trying to find a way to audit all of our Guide articles to determine which articles need attention - specifically the date an article was last updated, and whether the translated versions were also updated accordingly.
I have created a report in Explore that gives me the dates each translation was edited.
I exported the data to Excel and created a pivot table using the MAX function that allowed me to determine the last/latest date each article was edited (including the translated versions). Is there a way to create a custom metric in Explore that would give me a similar result?
