Hi Francesco,
Your approach would return the results based on transitions, however the approach seems correct.
I believe you would rather use the default measures “Issues created”, “Issues resolved”, and “Open issues” in your report
Please find description on them in our documentation page:
https://docs.eazybi.com/eazybijira/getting-started/measures-and-dimensions
Martins / support@eazybi.com