system
November 2, 2010, 12:31pm
#1
Hi Friends,
I need a help with the below listed formula
I have
Count of Incidents
I have Incident Closed date time ( eg: 11/1/2010 11:01:10 AM)
I need to find out
All Incidents that are closed <= 1 hrs
All Incidents that are closed > 1 hr
All incidents closed in > 1 day
All incidents closed in > 4 days
please guide me in creating the formula for the above.
Thanks in advance
Sam
sam4u (BOB member since 2008-01-09)
system
November 2, 2010, 12:44pm
#2
Hi,
Do you have something like “Incident Opened date time”? How else would you calculate how many hours/days it took to close an incident?
Marek Chladny (BOB member since 2003-11-27)
system
November 2, 2010, 12:46pm
#3
Marek,
Yes I have incident open date time with me.
please help me.
Sam
sam4u (BOB member since 2008-01-09)
system
November 2, 2010, 1:00pm
#4
Then take Closed Date Time and Open Date Time, calculate the difference between them and then use IF() statements to create “buckets” - “<= 1 hrs”, “> 1 hr”, “> 1 day” and “> 4 days”. Then use it in a report along with the “Count of Incidents” measure.
Marek Chladny (BOB member since 2003-11-27)
system
November 2, 2010, 1:04pm
#5
Marke,
Then can you please help me with the formula from where I can get the difference between dates in HH:MM:SS format.
Thanks,
Anil
sam4u (BOB member since 2008-01-09)
system
November 2, 2010, 1:34pm
#6
Sure. This old topic will help you:
I am trying to create a variable in Desktop Intelligence XI that will give me the diff between two dates. I used “=DaysBetween(<Admit Date & Time> ,<Order Date & Time>)” and I get just days. Is there a way to get his broke down to hours, minutes and seconds?
djohnson (BOB member since 2007-07-26)
Marek Chladny (BOB member since 2003-11-27)
system
November 2, 2010, 4:21pm
#7
Wowwwww…
Marek.
Thanks a lot for your help. You made my day
sam4u (BOB member since 2008-01-09)
system
November 2, 2010, 8:56pm
#8
You’re welcome 8)
Marek Chladny (BOB member since 2003-11-27)