{"type":"doc","content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"pagetree","parameters":{"macroParams":{"root":{"value":"User Guide"}},"macroMetadata":{"macroId":{"value":"a36da6e5-2e22-444e-a972-3305e159f069"},"schemaVersion":{"value":"1"},"title":"Page Tree"}},"localId":"3b666e79-ac60-459a-bd9d-4c5ae40e9662"}}]},{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"custom","localId":"66bd4432-a2c7-411f-b3ba-91b67639e5ea"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"The ","type":"text"},{"text":"Calculate","type":"text","marks":[{"type":"strong"}]},{"text":" options select how the data is displayed on the charts","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":204,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":386,"id":"5c9c3599-fa17-4de6-93f0-a0b065b5b4ea","collection":"contentId-455835688","type":"file","height":227}}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"table","attrs":{"layout":"wide"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[181.0]},"content":[{"type":"paragraph","content":[{"text":"Count","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1313.0]},"content":[{"type":"paragraph","content":[{"text":"Displays the number of Issues or Projects found","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[181.0]},"content":[{"type":"paragraph","content":[{"text":"Sum","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1313.0]},"content":[{"type":"paragraph","content":[{"text":"Aggregates all the values found","type":"text"}]},{"type":"paragraph","content":[{"text":"Example: 10 Story Points + 20 Story Points = 30 Story Points","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[181.0]},"content":[{"type":"paragraph","content":[{"text":"Average","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1313.0]},"content":[{"type":"paragraph","content":[{"text":"Takes the Sum and Divides by Issue Count","type":"text"}]},{"type":"paragraph","content":[{"text":"Example: 30 Story Points ÷ 2 issues = 15 Average Story Points per Issue","type":"text"}]}]}]}]}],"version":1},"cxhtml":"

Count	Displays the number of Issues or Projects found
Sum	Aggregates all the values found Example: 10 Story Points + 20 Story Points = 30 Story Points
Average	Takes the Sum and Divides by Issue Count Example: 30 Story Points ÷ 2 issues = 15 Average Story Points per Issue

Count

Displays the number of Issues or Projects found

Sum

Aggregates all the values found

Example: 10 Story Points + 20 Story Points = 30 Story Points

Average

Takes the Sum and Divides by Issue Count

Example: 30 Story Points ÷ 2 issues = 15 Average Story Points per Issue

"}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Any ","type":"text"},{"text":"Number","type":"text","marks":[{"type":"strong"}]},{"text":" field will be selectable on the field list","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":204,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":600,"id":"77f9d52a-d330-438d-89eb-6f6ddef26fe3","collection":"contentId-455835688","type":"file","height":477}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"The calculated value is shown as a column in the legend table, the y-axis label on bar charts and the calculated ","type":"text"},{"text":"%","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Scripted and calculated fields from Jira add-ons (e.g. ScriptRunner or JMCF) can also be used as a Count value, as long as they are number fields.","type":"text"}]}]}],"version":1},"cxhtml":"

Scripted and calculated fields from Jira add-ons (e.g. ScriptRunner or JMCF) can also be used as a Count value, as long as they are number fields.

"}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"For calculations involving time logs, the default ","type":"text"},{"text":"time unit","type":"text","marks":[{"type":"strong"}]},{"text":" is hours and can be changed to days, weeks, months, or years","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":258,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":732,"id":"b1fd7040-a73f-4106-8567-9786778feed7","collection":"contentId-455835688","type":"file","height":744}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Calculations can also be made that compare multiple date fields","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":306,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1060,"id":"9b99e3f5-3626-4da3-89a1-9f4ac11c8776","collection":"contentId-455835688","type":"file","height":92}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Under common fields, you'll find the following options for date comparisons","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Time Since","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Calculate the time since a specific date based on the selected date field","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Time Until","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Calculate the time until a specific date based on the selected date field","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Time Between","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Calculate the time between two date fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Time to Resolution","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[340.0]},"content":[{"type":"paragraph","content":[{"text":"Calculate the time between creation and resolution. This calculation uses the Resolved date (the date a resolution is set on the issue).","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":149,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":772,"id":"fcc37e2a-fbb4-4cb7-a495-913ed504c9ba","collection":"contentId-455835688","type":"file","height":142}}]},{"type":"paragraph","content":[{"text":"Check 'Include unresolved issues' – if you choose to include these issues, their time to resolution will be between creation and the current time. ","type":"text"}]}]}]}]}],"version":1},"cxhtml":"

Time Since	Calculate the time since a specific date based on the selected date field
Time Until	Calculate the time until a specific date based on the selected date field
Time Between	Calculate the time between two date fields
Time to Resolution	Calculate the time between creation and resolution. This calculation uses the Resolved date (the date a resolution is set on the issue). Check 'Include unresolved issues' – if you choose to include these issues, their time to resolution will be between creation and the current time.

"}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"rule"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"include","parameters":{"macroParams":{"":{"value":"DEVCC:_Hidden_Support_Footer"}},"macroMetadata":{"macroId":{"value":"53e9db98-729b-4caf-aee8-72213f70153a"},"schemaVersion":{"value":"1"},"title":"Include Page"}},"localId":"cb62c8d7-fdb4-450f-bd05-110e1b484f9d"}},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"include","parameters":{"macroParams":{"":{"value":"DEVCC:_Hidden_Standard_Footer"}},"macroMetadata":{"macroId":{"value":"626800c1-1a85-422f-80d1-218b549c0d93"},"schemaVersion":{"value":"1"},"title":"Include Page"}},"localId":"e9b601f9-5305-4e54-9e1c-3b4fd2d5c72a"}},{"type":"paragraph"}],"version":1}

Calculate

The Calculate options select how the data is displayed on the charts

Any Number field will be selectable on the field list

The calculated value is shown as a column in the legend table, the y-axis label on bar charts and the calculated %

For calculations involving time logs, the default time unit is hours and can be changed to days, weeks, months, or years

Calculations can also be made that compare multiple date fields

Under common fields, you'll find the following options for date comparisons