Hi community,
I have imported a CSV file into EazyBi of a list of pages in Confluence I got from running a SQL query on the Confluence database. The idea is to identify old pages for archiving.
I have fields for the creator, created date, last modified date and title.
I want to create a report that can group the pages by date and author.
Any pointers please?
Thanks
Hi @cokefour,
You could create that report using eazyBI Confluence app by putting Time, Author and Page dimensions on report rows and using the measure “Pages updated”. The app also allows you to reach the page right from the report.
However, if you are building your own data cube from an SQL source, you need to map Creator and Title as dimensions and map the dates to the Time dimension both as properties and measures. Please read more about the data mapping here - Data mapping.
Then, you might use these measures to display the relevant pages in reports.
Regards,
Oskars / support@eazyBI.com