Hello,

I have created a chart in a subreport of a report which is showing calls remaining at the end of the day and split by priority. However I also want to add the total calls on this graph but struggling.

The chart is set up to On change of priority show values of Distinct Counts of 8 formulas dependant on the day these are as follows:-

@count1: If {@logdate}<=dateadd("d",-8,CurrentDate)and (isnull({opencall1.closedate}) or {@Closedate}>dateadd("d",-8,CurrentDate))
then {opencall1.callref} else tonumber ({@null})

@count2: If {@logdate}<=(DateAdd("d",-7,CurrentDate))and ({opencall1.closedate}='' or
{@Closedate}>(DateAdd("d",-7,CurrentDate)))then {opencall1.callref} else tonumber (@null})

and so on until it's current date minus 1 day.

The @Closedate formula is just as follows:
If {opencall1.closedate}<>'' then Date({opencall1.closedate})
I have done this as the closedate is a string and not a date field.

I have had to swap series and groups and color by series and not group

How can I include the total calls for each day i.e. High, Med and Low for all 8 days.

High, medium and low are the priorities

The 8 formulas are if the logdate of the call is before or on that particular date and the call is not closed then count that call i.e. the relevant open support call of that priority.

So the total would be all of the total of the 3 columns for each day. So I need 4 columns for each day.


I have also made a crosstab for this report but I had to do a manual crosstab to incorporate all the info.

I did try ordering the priorities in a specified order and then adding a new group which was the three priorities together but it does not show this. However if I put this to the top of the order it does show this and 2 of the other priorities.

Thanks in advance as I am pulling my hair out.

Annette

p.s. sorry if this is explained terribly....