Rich Filter Smart Counters macro is only showing for first month and rest as 0

[Sunil Runkana]

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. 

[Sunil Runkana]

Resolved. Not sure what went wrong. could be some sort of glitch. Built a new rich filter from scratch which is similar the previous one and macro's working fine