To calculate total number of defects extracted using macro - Insert JIRA issue, table transformer

Question

Hi Everyone,

I need help with the below task.

I am extracting the defects from JIRA to confluence page using Macro - Table transformer and inside that another macro - Insert JIRA Link.

I am calculating the number of days taken to resolve and issue, for that I am using the  SQL Query:

Attaching the heading of the table of how it looks on publishing for reference:

Here my ask is:

1. Is there a query i can use to calculate from the column "time to resolution"(this columns would have the number of days in it) - what defects are older that 14 days or any number of days, if that can be filtered?

Ripanjot Aneta · Answer

Thanks Katerina.

Katerina Kovriga {Stiltsoft} · Answer

Seems to be a duplicate, tried to answer here https://community.atlassian.com/t5/Confluence-questions/To-calculate-the-total-number-of-defects-extracted-using-macro/qaq-p/2029614#U2030149

Ripanjot Aneta · Answer

Want to add, i Used Table filter macro to calculate the number of defects. But that column does not have a heading.