Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Service management report different to SQL query on Google Spreadsheet integration

Marcelo Gallego
Contributor
June 8, 2021

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:

Captura de pantalla 2021-06-08 a las 16.40.24.png

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

Captura de pantalla 2021-06-08 a las 16.42.34.png

Does anyone guess what I'm doing wrong?

Thanks and regards.

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, opsgenie migration, jira service management, incident response, on‑call management, alerting tools, migration guide, devops operations, service reliability, atlassian learning, migration best practices, opsgenie support, IT operations

Join the Opsgenie Migration group 🚚

Heads up! Opsgenie's features are moving to Jira Service Management and Compass. Planning your migration? Join our dedicated group for resources and tips from Atlassian and the Community to ensure a smooth transition.

Check it out ↗
AUG Leaders

Atlassian Community Events