Custom days open calculated field

[BlueKai Support]

Does anyone know of a plugin or code to create a calculated field for days open.

We are trying to track the SLA for high priority issues.

I thought this would be pretty common. Does anyone has best practices to do so?

[CelesteCS]

Hello!

For any calculations in Confluence, including any manipulations with dates and table data, you may use CelesteCS Math for Confluence.

Assume you have a table with three columns and three rows on your page – from A1 till C3, where row 1 is the header row. The sum calculation formula for rows 2 and 3 will be simple:

SUM(Table1.A2:C3)

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.

Thanks!

[Renjith Pillai]

https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+Fields#ScriptedFields-TotaltimethisissuehasbeenInProgress