How to count the time in a specific state month by month?

[Elita.Kalane]

Hello @Guilherme_Zambonato

Thanks for posting your question!

The solution you are looking for can be achieved by using JavaScript code. Please follow this Community post to import a new field, “Workdays in Status by months”

Time that tickets stayed in a specific status during a specific period

Hi, The default measure of Days in transition status does not split the days by the period selected in the report. Instead, it shows the full number of days spent in the status for the period when the issue transitioned from the status. It is possible to create a workaround with a Javascript calculated custom field. I used the following advanced settings for the solution: [jira.customfield_wd_inst_by_month] name="Workdays in status by months" data_type="decimal" measure=true multiple_dimensi…

When you update your eazyBI advanced settings with the code in the Community post I shared, please select a new field, “Workdays in status by months,” for import and use it in your report similarly to the screenshot below. Note that the code will only work at the month level.

Best wishes,

Elita from support@eazybi.com