Date of Dataset

[HANI Joseph]

Hello,
Just to let you know that we are using your Add-On and it’s really useful, we are looking for our KPI with it. But we also run into a problem of date.

For example, we are trying to have the number of issue types from a month which is from 01 January to 31 January but actually, it’s showing the number of issuetype from 01 January to 01 February. A little bit disturbing cause we really want to know only January data. And the other month’s data is starting on 02 February.

We have ~ 250 Tickets/month so it’s really important for us to track the exact number per month. Anything about this error ?

Waiting for your return,

Have a nice day,

Regards,

Joseph

‌

[HANI Joseph]

Example of JQL : project = SN AND "My Country[Dropdown]" = Romania AND created >= 2022-01-01 AND created <= 2022-12-01 ORDER BY created DESC

[boydo]

Hi Joseph,

I just wanted to make sure it wasn’t as simple as the <= in this part of the query
...AND created <= 2022-12-01 ORDER BY...

and whether changing it to < might give you what you’re after?

[HANI Joseph]

Hello Boydo !

Thanks for your return !

I have tried to change (with something simpler) from :

• project = SN AND created >= 2022-01-01 AND created <= 2022-12-31 ORDER BY created DESC

to

• project = SN AND created > 2022-01-01 AND created < 2022-12-31 ORDER BY created DESC
• project = SN AND created <= 2022-01-01 AND created <= 2022-12-31 ORDER BY created DESC
• project = SN AND created >= 2022-01-01 AND created <= 2022-12-31 ORDER BY created DESC

I confirm that it change nothing on the visual, we keep getting the same visual error, and also it’s still takin 1 February

‌

Have a nice day !

Joseph