To calculate difference of days (aging) across month.

[#1]

Hi there,

I have to calculate aging i.e difference between the reported date and last resolved date for incidents. but such is the following requirement.

Say if the reported date is 6th June and the resolved date is 10 th August.

I have to show aging across the the in between months in such a manner:

i.e. the Aging for June will be the difference between the last working day of June say 30th June and the reported date, similarly the aging for the month of July will be the last working day of July say 31st July and the reported date, for August aging will not be calculated as the Incident was resolved in August.

Also if the Month(Reported Date)=Month(Resolved Date) Aging will not be calculated.

Now I have to show it in a graphical manner say when I select an incident

Can Anyone help me in understanding how the calculation should go forward. and how the dimension calculated dimension will be.

Any help will be appreciated.    

Thanks and regards

Rahul

[ecolomer]

I'm not sure I understood your request.

You can get the time between two dates making the time difference between them.

Tsst this script, to have number of days in each month

CON:

LOAD * Inline [

Contrato, Fec_Ini, Fec_Fin

120, 25/07/2015, 05/08/2015

132, 27/07/2105, 30/09/2015

154, 01/08/2015, 10/11/2015

178, 05/08/2015, 20/10/2015

190, 01/09/2015, 01/09/2015

];

Otro:

LOAD

  Contrato,

  Fec_Ini,

  Fec_Fin,

  IterNo() as NM,

  Month(Fec_Ini) + IterNo() -1 as Mes

resident CON

While Month(Fec_Ini)+IterNo() -1 <= Month(Fec_Fin);