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!

BUT.

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

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

374 views 20 10
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