I'm trying to make a new chart using eazyBI like the following:
Where X is the number of issues resolved during a week, and Y is the number of weeks in which this number of issues has been resolved.
For example in the chart we can see that in 2 different weeks we have only resolved 1 issue, in two different weeks we have only resolved 5 issues, and in 4 weeks we have resolved 6 issues. This could translated as in:
Week 1 : 1 issue resolved
Week 2 : 5 Issues resolved
Week 3: 1 Issue resolved
Week 4: 6 Issues resolved
Week 5: 6 Issues resolved
Week 6 : 5 Issues resolved
Week 7: 6 Issues resolved
Week 8: 6 Issues resolved
I haven't found the way to do this with eazyBI, has anyone done this? or anything similar?
Measures: select issues resolved
Rows: select the time dimensions and use the weekly hierarchy
Perhaps you are looking for a report to find weeks where the most issues were resolved.
On top of what Fabian already recommended maybe I can suggest another idea - MonteCarlo chart with Resolution interval dimension where you could customize the intervals.
See a discussion here: https://community.eazybi.com/t/montecarlo-chart/4996
Martins / eazyBI