Confluence - macro of statistics/reports Edited

Hi,

I'm willing to find macro or report of statistics. to get some insights from a dynamic chart we work with in confluence 
(this is the page, hope you can see it https://wiki.clicksoftware.com/display/SSDFC/Service+Edge+POD+Change+Management+Log?&pagepropertiesreport.serverrender)

We would like to know:

  1. How many PCMs (each row in the chart which in status New) are opened each week?
  2. How long does it take for a PCM to be finished? Distribution per days
  3. How are the PCMs divided between the teams (per the assigneee column) 

Hope you can guide me how to use it in Confluence instead of adding the data to excel table and process there.

Much appreciated!

1 answer

Hi Ortal,

The page you shared is not permitted for external users.

Do you use Table Filter and Charts add-on? If not, you can try out this add-on. It has Pivot Table maro for different calculations, Chart from Table macro to build a dynamic chart and Table Filter macro to filter table and calculate totals. Hope this will help you.

 

 

Hey Andrey,

How can I share with you the above page we use?

https://wiki.clicksoftware.com/display/SSDFC/Service+Edge+POD+Change+Management+Log?&pagepropertiesreport.serverrender

So that we can be more productive

Thanks,

Ortla

There are several ways:

  1. You can create a temporary account for me and send to my email credentials.
  2. You can set an anonymous access to a page or a space. In this case it is better to create a new space with a copy of a page (or a similar page without confidental data).
  3. You can login to our demo site as a Guest and create a similar page.
  4. You can create a private support ticket in our support system where you can share some screenshots of what you have even if it has any confidetial data.

I've created a page in your demo site with copy of our chart:

https://demo.stiltsoft.com/display/tblfilter/Service+Edge+POD+Change+Management+Log

Our chart based on 

each row of the chart is lnk to another page which is based on template we've created

We would like to know:

  1. How many PCMs (each row in the chart which in status New) are opened each week?
  2. How long does it take for a PCM to be finished? Distribution per days
  3. How are the PCMs divided between the teams (per the assigneee column)

I'm in the process of creating reprorts. Please, join this page to discuss details (we can use comments on this page).

The page was removed by a backup process. There is a copy.

Thanks Andrey!

Can I copy this page content to my conluence even though I don't have these paid macros yet?

If not, how can i copy this?

 

Thanks!

The best way is to use free Source Editor add-on. In this case you can save a page as text file somewhere and then restore it in several clicks.

If you copy and paste contents of the editor to Confluence instance with those macros, you can loose contents of those macros while saving a page (Confluence can clean it up, I faced with this problem several times).

OK. I would be very much appreciateed if you can provide me with the accurate steps how to use free Source Editor add-on (save a page as text file , restore it , etc)

 

Thanks

To copy page storage click this button on a page

2017-06-07_14h52_06.png

and copy all the text from an opened window, save it somewhere for the future needs.

After you istall Source Editor add-on you'll find a new button in the editor (it appears only if the page is saved, so if you create a new page, save it blank and edit again)

Source_Editor_button.pngclik the button and replace the contents of a modal dialog with previosly saved storage format

2017-06-07_14h52_51.png

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...

381 views 21 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