Joined: 10 Mar 2009
Online Status: Offline
Posts: 9
Topic: Group Conditionis not Known Posted: 10 Mar 2009 at 8:05am
Hi,
Wondering if anyone can help me.
I am modifying a report that someone else wrote and it basically returns an average elapsed time for a month based on how quickly agents close tickets.
I know have to modify this for a weekly stat but when I modify the formula field to include "weekly" it scomes back saying that the "The group condition is not known"
Here is the formula field pre editing - Round(Average ({@Elapsed Days}, {@dtCompleted}, "monthly"),2)
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 11 Mar 2009 at 7:12am
The Average function is computing the average of the data based on the grouping called 'monthly' in the report. If you check the GH sections of the report one is called 'monthly'. Not knowing the report, it may be a data field, but is probably formula. If is a formula, you can modify the logic in it to make the report work as desired. If you want monthly and weekly, you will probably want to create a new grouping that will work correctly.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
