Calculate the number of days taken by a bug_id from step1 to step2

[former_member363950]

Hello,

I want to fill in a report a key figure which calculates the number of days between the date where

I. a bug_id has been 'registered' (characteristic value of characteristic state) to date where the bug_id has gone to the step 2 'realised' (characteristic value of characteristic state).

II. And the number of days from step2 to step3.

III. And the number of days from step3 to step4. This woulb be the last value if step 4 is the last step.

Hier we have 0date and state characteristics and i want to calculate the number of days between the differents steps.

Can you please help.

Thank you for your help

Ar.

[Former Member · Accepted solution]

Hello Dear

you can do it in transformation/Transfer/update rule or can directly do it in query. In query Date1-date2 will directly give you the no of days.

Thanks

Tripple K

[Former Member]

Hi Arnaud

1. create a KF named counter, with exception aggergation count all values <> 0.

2. in your transformation make that as constant to value 1.

3. load data into target.

4. in Bex query you need to creat a formula variable which will get the date range of when step 1 starts or occur & date when step 2 occurs.

5. create a calc key figure , add counter in it & in its aggergation select count all values <> 0 & aggergation on date.

6. create a restricted KF where you restric calc key figure created by the formula variable which gives date range.

so this resticted KF will give you no of days between the steps.