Objective: To show the number of JIRA's created for each month for first quarter
Issue: Incorrect count shown for first month and zero for rest all months
Below is the rich filter and smart filter created in JIRA
My Rich Filter - "project = ABCD"
Smart Filter created
Inflow Rate
Label JQL
JAN created >= "2023/01/01" AND created <= "2023/01/31"
FEB created >= "2023/02/01" AND created <= "2023/02/28"
MAR created >= "2023/03/01" AND created <= "2023/03/31"
Added Rich Filter Smart Counter macro to confluence and expected to see the results as
14 6 28
JAN FEB MAR
But results shown as
2 0 0
JAN FEB MAR
When I looked JQL built internally for FEB to under stand the root cause, what i noticed is JQL is as below
project=ABCD AND resolved >="2023/01/01" AND resolved <="2023/01/31" AND created >= "2023/02/01" AND created <="2023/02/28"
Ideally the JQL should be
project=ABCD AND created >= "2023/02/01" AND created <="2023/02/28"
But unfortunately I don't have control over that JQL built.
Can anyone help let me know where did I go wrong ? Note: The same above Rich Filter is working fine on JIRA dashboard with Rich Filter Smart Counter gadget. The issue is only with Confluence results.
