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: * How many PCMs (each row in the chart which in status New) are opened each week? * How long does it take for a PCM to be finished? Distribution per days * 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!

To copy page storage click this button on a page 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) clik the button and replace the contents of a modal dialog with previosly saved storage format

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

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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence - macro of statistics/reports

ortal ohayon

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:

How many PCMs (each row in the chart which in status New) are opened each week?
How long does it take for a PCM to be finished? Distribution per days
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!

Accepted answers

All comments

Andrey Khaneev _StiltSoft_

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.

ortal ohayon

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

Andrey Khaneev _StiltSoft_

There are several ways:

You can create a temporary account for me and send to my email credentials.
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).
You can login to our demo site as a Guest and create a similar page.
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.

ortal ohayon

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:

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

macro

report