Basic group question

[ptrifile]

I have what i believe is a basic question and hoping someone can shed some light.

I have 2 tables im pulling a report from and im only trying to put two fields on a report, they are "Split_Name" and a Service level formula that takes "answer_under_SL" divided by "Calls offered"

My question is when i group by "Split name" i get the list of all the splits but the service level is the same for all of them (which it shouldnt be) its like its only showing the first service level in the table and then repeating it for each split name. Example below:

Split Name Service Level

Split - a 99.00
Split - b 99.00
Split - c 99.00

The desired outcome would look more like this:

Split - a 99.00
Split - b 75.00
Split - c 82.00

Is there something that i am doing wrong? hopefully there is enough info here for someone to help.

Thanks in advance

Paul

 

[fisheromacse]

I few questions ...

First check the joins and links to ensure that there is not data duplication and/or erroneous linking.

Do you have any groups other than the SplitName?

Does the service level formula have any sort of reset?

or criteria that forces the service level formula to only calculate for the current split value?

 

[ptrifile]

fisheromacse, thanks for the help!

1. the joins and links seem to be ok.
2. There are no other groups besides splitname
3. here is the forumla for service level:

if {@Calls_offered}= 0 then 0 else {splits_daily_history1.ans_under_serv}/{@Calls_offered} %1

Am i approaching this the wrong way?

Thanks again for the help

Paul

 

[fisheromacse]

what are the contents of the {@Calls_offered} formula?

 

[ptrifile]

{@calls_offered} is:

{splits_daily_history1.count_acd_incoming} +
{splits_daily_history1.count_aban_before} +
{splits_daily_history1.count_aban_after} +
{splits_daily_history1.count_aban_from_ring}

 

[lbass]

Is split_name based on a formula? Please show the contents.

-LB

 

[ptrifile]

No, split_name is not based on a formula. I grouped it by the field splittable1.split_name.

Paul

 

[lbass]

The formula for {@callsoffered} is only picking up one row of data for one row--is that your intent?

Please show us a sample of what the data looks like at the detail level if you place{splits_daily_history1.ans_under_serv} and {@Calls_offered} in the detail section.

-LB

 

[ptrifile]

I think thats my intent...but if you tell me i should be doing it differently to get the desired results i am more than willing to listen!

Sample data with those fields in the details:

ans under serv calls offered
1 3
1 1
0 0
2 2
2 2
2 2
0 0
2 2
0 0
2 2
3 3


it is listed that way for every 15 minute interval for the entire day and for each split.

Hope this helps! Thanks again for your attention to this.

Paul

 

[lbass]

So don't you really want to see a summary for these at the split name group level?

-LB

 

[ptrifile]

Yes, I am looking to get the Service level which is "answered under serv" divided by "calls offered" for each split. I am looking for the data to simply show the split name and service level next to it like below:

Split - a 99.00
Split - b 75.00
Split - c 82.00

I thought this would be something easy to do grouping by split_name.

Paul

 

[lbass]

if sum({@Calls_offered},{splittable1.split_name}) <> 0 then
sum({splits_daily_history1.ans_under_serv},{splittable1.split_name}) % sum({@Calls_offered}, splittable1.split_name})

-LB

 

[ptrifile]

I get the error "a number, currency amount, boolean, date, date-time, or string is expected here."

then it highlights the last "splittable1" at the end.


Thanks again

Paul

 

[lbass]

I thought you grouped on {splittable.split_name}? Substitute the field you grouped on for this if different. Also please post the formula as you created it.

-LB

 

[ptrifile]

Thanks lbass, i would have never got this working without you. you had me put in

if sum({@Calls_offered},{splittable1.split_name}) <> 0 then
sum({splits_daily_history1.ans_under_serv},{splittable1.split_name}) % sum({@Calls_offered}, ({splitTable1.Split_Name}))

i modified it to the below and it worked:


if sum({@Calls_offered},{splittable1.split_name}) <> 0 then
sum({splits_daily_history1.ans_under_serv},{splittable1.split_name}) % sum({@Calls_offered}, splittable1.split_name})


thank you so much for the help!!!!

Paul

 

[ptrifile]

sorry, the other way around....

 

[lbass]

You don't need that extra set of parens--it was the curly bracket that I left off on the left end of the field. If you had entered the field by using the dropdown list, it would have automatically been correct. I guess you actually copied my formula exactly. Sorry.

-LB