Viewing second-most recent version of an embedded document

I would like to host our monthly departmental service desk statistics in Confluence. With an embedded Excel doc, I can update the document with new data each month and executives can always check that same page for the most recent performance--this is great!


They would also like to be able to compare this month with last month. That is, show the second-most recent version of the document in another page or lower on the page. Is this possible? Or do I have to manually upload each file and change the confluence page text each time to show this month and last month?

Any ideas welcome.

2 answers

1 accepted

0 votes
Accepted answer

The data is all available in a SQL database, so we could run a 6mo analysis, if needed. But Excel was not made to handle so much data, so I don't want to design our system like that. I think I will just manually update the attachments.

oK, so you did it right already and have all the data :) So just use the excel to present the resultset from the queries dynamically. One query per tab, and then show the tabs inside the wiki.

Dont know, though, how that will work with passwords, which might be necessary to update the excel tables, could be that every user who can update the excel needs an DB account.

And next time once ypu solved this, they ask for a 6months delta analysis ... Do it right and store ALL data and use a datefilter inside excel to consolidate the numbers you need to tab 1. confluence ist just there to display tab 1 of the excel.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,116 views 59 8
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you