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

This widget could not be displayed.

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.

This widget could not be displayed.
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 yesterday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

208 views 2 4
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