Total ticket count is wrong

[Sowmiya]

dont understand why the total of the tickets created differ even though each component has the same count. why is time to resolution & response stating 59 tickets but status of all ticket says 61

[Luke]

Hi,

You can make a own Measure Like this:

– annotations.total=sum
[MEASURE].[Issues created]

More:

Total is wrongly calculated

Hi, I’ve prepared measure Delta+ to calculate time of overloaded issues (to find how much): CASE WHEN NOT IsEmpty([Measures].[Sprint Remaining Estimates committed]) THEN (CASE WHEN ([Measures].[Hours spent] - [Measures].[Sprint Remaining Estimates committed]) > 0 THEN ([Measures].[Hours spent] - [Measures].[Sprint Remaining Estimates committed]) ELSE 0 END) ELSE (CASE WHEN ([Measures].[Hours spent] - [Measures].[Sprint remaining estimated hours added]) > 0 THEN ([M…

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members

Note: I hope this was the solution i use too. I have currently no Access to my eazybi Measures …
If not, the solution is in the topics

[martins.vanags]

Hi @Sowmiya

That is a typical behavior in eazyBI with “Total” row when using multi-value fields imported as dimensions. Note that component is a multi-value field and you can add more than 1 component to issue.

In this case, the doublecounting is at the total row from the issues which has more than 1 component in Jira.

Try exploring eazyBI distinct measures: “Issues created count” and “Issues resolved count” to count each issue just once in the Total row.

Martins / eazyBI