I would like to find a solution for following issue:

I have a table with following  data

0900                          Off Duty

0901                           Available

0902                           On Call

0905                           Available.

 

I would like to find the Time stamp of the first time status "Available" appears.

I made this formula but it is nog correct because it evaluates all records and the last one is not matching "Available".

 

if {AgentActivityLog.StatusKey} = "available" then
    time(minimum({AgentActivityLog.StatusDateTime},{@SV_Group StatusDate}))
else
    time(maximum({AgentActivityLog.StatusDateTime},{@SV_Group StatusDate}))

 

Thanks for the help.

stijn

 

1.  Create a running total for each status.  This will be a count of the timestamp.  Under Evaluate, select Use a formula, click on the formula button and enter something like this:

 

{table.status_field} = 'Off Duty'

 

The value in the formula will be based on which status the count is for.  Under Reset, select On Change Of Group and select the group at the level right above the timestamp/status data.

 

2.  For the section where you're displaying the data, set a suppression formula that looks something like this:

 

({table.Status_field} = 'Off Duty' and {#Off Duty Count} > 1) or

({table.Status_field} = 'Available' and {#Available Count} > 1) or

...<continue for each status>

 

Note where I put the parentheses - this is VERY important because the formula won't evaluate correctly otherwise.

 

-Dell

Thanks a lot for your support.  This works well, but it is hiding / showing statuses in the details section.  I would like to create a formula which I can put for example in the report footer, showing the timestamp a specific call center agent was in "available" state that day.  Can you please assist some more, I'm lost.  In SQL I would need to use a findfirst command and show the value.

Thanks,

S

 

-Dell