Issues resolved <= 1w measure

Questions & Answers
1

Hello team

I have this problem :

I added two new measure :

1: Issue resolved < 1w

Code :

SUM(
Except(
[Resolution interval].[Resolution interval].Members,
{
[Resolution interval].[(none)],
[Resolution interval].[… - 06] – interval members could be different
}
),
[Measures].[Issues resolved]
)

  1. Issue resolved <= 1w

code :

SUM(
Except(
[Resolution interval].[Resolution interval].Members,
{
[Resolution interval].[(none)],
[Resolution interval].[06 - …] – interval members could be different
}
),
[Measures].[Issues resolved]
)

I have always the same result in two column .

Can you help me please ?

I find also this code

([Measures].[Issues resolved], [Resolution interval].[… - 06])

it doesnt work , and why in documentation we dont use (except ) in the two cases ? Please

Documentation : https://docs.eazybi.com/eazybijira/learn-more/learn-eazybi-through-examples/issue-resolution-days-lead-time-reporting

Image 4.png

Regards

Karim

2

Hello @karim

Try changing the definition for Resolution interval and have more intervals there.
Then you can address the right intervals more precisely.

See more about interval dimensions here:
https://docs.eazybi.com/eazybi/analyze-and-visualize/interval-dimensions

Martins / eazyBI support