JIRA Eazybi Calculation.

[Manoj]

Hi All,

I am trying to create below type table in eazybi however, i am able to draw the structure using time dimension and calculated fields.

I have status as resigned, so the numbers of resigned happens in any month, should get counted in respective month matching the field like A, B, C D, [ so in Apr,i have resigned 2 in A, 3 in B and so on) 

	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Jan-00	Jan-00	Nov-18	Dec-18	Jan-19
A
B
C
D

Please suggest the way to calculate, i have been trying alot but not able to solve.

Thanks, M

[Kat Jansen · Accepted solution]

Hello M, 

You're trying to track the issues that transition to Resigned each month segmented by a field value?

If so, use the measure Transitions to Status and have Transition Status in Pages with Resigned selected.

Time and your Field should be in Columns and Rows respectively to match your structure.

Let me know if this is what you're looking for?

Thank you,
Kat