How too create a year-on-year (YoY) comparison on a monthly basis for resolved issues in a table using eazyBI for Jira
| Year | Jan | Feb | Mar | … | |||
|---|---|---|---|---|---|---|---|
| 2024 | 31 | 55 | 45 | … | |||
| 2025 | 33 | 90 | 56 | … |
Helloooo! welcome to the community.
This is a basic one, you can do it like the below screenshot. However, the Time dimension can’t be split between Rows and Columns
Although, I suggest reviewing the Creation and visualization of reports section
1 Like
Like @Nacho I needed a similar measure, but I did it differently:
I used current year and previous year for the columns, that allows me to compare the various measure I want against each other on an annual basis. I don’t do it month by month though.
Cheers
Dave
Hi @Y_Y
Welcome to eazyBI Community!
@Nacho @David_Horne - Thanks for joining a discussion!
All suggestions are very useful!
Another recommendation from my side is to use the standard calculations. Create a simple report having Time dimension in Rows and Pages. Select the Month level for the Time dimension in Rows.
With using the Standard calculations (Add standard calculations) - left click on measure name → Add Calculated → Time ago → Year ago eazyBI will automatically return the results for the previous year also on monthly basis
See screenshots below:
Best wishes,
Elita from support@eazybi.com
2 Likes
Hi Elita,
Thank you very much for your support !
I’ve met a new problem when I tried to follow your guide, the month of July/Aug/Sep/Oct 2025 are not be shown even if the “Noempty” is not selected. Then how to shown the null month members ?
Best Regards,
Hi @Y_Y
Indeed, that may be the case. eazyBI only imports those date members that are somehow associated with an issue (either through Issue creation, resolution, due or custom date fields).
You can, however, create the missing date members by adding them manually in the Time dimension. Follow the steps described here - Time dimension
If you have any questions or get stuck, let me know!
Best wishes,
Elita from support@eazybi.com
2 Likes
Thanks a lot ! It’s working well 
1 Like