Service management report different to SQL query on Google Spreadsheet integration

[Marcelo Gallego]

Hi!

I'm a little bit confused. trying to use the Jira integration with Google Spreadsheet. I'm looking for creating an automated KPIs dashboard.

I have a report in Service Management which shows Bug, support and New features (created and resolved) by month.

If I set it on "Past year by month", it shows to me this numbers from May:

However, if I make this sql query through Google Spreadsheet integration the result will be different:

created >= 2021-05-01 AND created <= 2021-05-31 AND project = PB

Does anyone guess what I'm doing wrong?

Thanks and regards.