BusinessObjects Board

Need help with a formula

building reports webintelligence
#1

Hi Friends,

I need a help with the below listed formula

I have

  1. Count of Incidents

  2. I have Incident Closed date time ( eg: 11/1/2010 11:01:10 AM)

I need to find out

  1. All Incidents that are closed <= 1 hrs
  2. All Incidents that are closed > 1 hr
  3. All incidents closed in > 1 day
  4. All incidents closed in > 4 days

please guide me in creating the formula for the above.

Thanks in advance

Sam

sam4u :us: (BOB member since 2008-01-09)

#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 :slovakia: (BOB member since 2003-11-27)

#3

Marek,

Yes I have incident open date time with me.

please help me.

Sam

sam4u :us: (BOB member since 2008-01-09)

#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 :slovakia: (BOB member since 2003-11-27)

#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 :us: (BOB member since 2008-01-09)

#6

Sure. This old topic will help you:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#7

Wowwwww…

Marek.

Thanks a lot for your help. You made my day :slight_smile:

sam4u :us: (BOB member since 2008-01-09)

#8

You’re welcome 8)

Marek Chladny :slovakia: (BOB member since 2003-11-27)