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
1 Like