Recent content by LouiseR

Hello I have set up a business rule that uses an autotask to send an email (using MS Outlook) to an assignee when an assignment is created for them. Does anyone know how I can reassign a call if necessary and email the new assignee with the details? I can reassign the call ok, but the email...

Sorry! 9am to 6pm (day 1) = 9 hours, then 7am to 3pm (day 2) is 8 hours which is 17 hours in total. Louise

Hi Richard I meant 9am to 6pm (day 1) = 9 hours, then 7am to 3pm (day 2) is 6 hours which is 17 hours in total. Where do I set up the resolution time to take into account the helpdesk hours? When calculating the time the call has been open, can I set this to take into account the helpsdesk...

Hello If the hours of operation are set at 7am to 6pm and a call is opened at 09:00 yesterday, closed at 15:00 today, is the total time the call is open 17 hours (based on hours of operation) or is it based on the 24 hour clock? Does the Maximum resolution time take the hours of operation into...

Thankyou- I will! Louise.

Hello Does anyone know of any forums I can join for for Heat configuration? Thanks, Louise.

Hi I am new to Oracle and I am trying to introduce a second archived redo log destination. Setting this up is all fine, but I am looking for advice on how and when to archive the archives. Do I simply delete the second destination archived logs after a few days, or is it more advisable to keep...

Thanks very much lbass! Worked a treat- I'll remember that trick! Louise.

Sorry, I meant Top N. The group sort expert item is greyed out from the report menu as is the icon. Louise.

Hi synapsevampire I have tried this, but the group n function does not seem to work with running totals- the icon is greyed out and the running total does not appear in the drop down list. Also, do you mean to have 2 groups, the first on Cause and the second on application? Thanks Louise.

What I ultimately want to do is get a top 10 of cause and application together based on the formula, eg Program Antivirus has 3 entries then Program error Apps has 2 entries etc. Thanks very much Louise.

Hello Here'a wee example of what I am looking for, formula column is the result of the formula you gave, req'd is what I would like to be held in the total: Cause Application formula req'd Program error Anti-Virus 1.00 1.00 Program error...

Hi again I don't think I've explained myself properly: if the next record is the same as the current one, total=1, if the next one is the same again total =2, etc. Then, if the next record is not the same as the previous, total = 0. The formula given, just gives a series of 1s. Thanks again...

P.S. This is what I have tried so far.. local numbervar total:=1; if ({CallLog.Application}= Next ({CallLog.Application})and {CallLog.Cause} =Next ({CallLog.Cause})) then total:= total+ 1 else if ({CallLog.Application}<> Next ({CallLog.Application})and {CallLog.Cause} <>Next...

Hi I am trying to calculate a running total that resets if a criteria is not met, i.e if the next value of a field is the same as the current one, then add one to a total, if the value is not the same, then reset the total to zero. Can anyone help? Thanks, Louise.