Tips and Tricks
 Crystal Reports Forum : Crystal Reports .NET 2003 : Tips and Tricks
Message Icon Topic: Line Chart Post Reply Post New Topic
Author Message
Caicai
Newbie
Newbie
Avatar

Joined: 16 Sep 2007
Location: Australia
Online Status: Offline
Posts: 2
Quote Caicai Replybullet Topic: Line Chart
    Posted: 16 Sep 2007 at 11:42pm

Applications

Calls Answered

Calls Ans After Threshold

Calls Abn After Threshold

GOS Calculation

Note

A

6

3

4

(6-3)/(6+4) =                  3/10= 10%

 

B

8

2

1

(8-2)/(8+1) =                   6/9=67%

 

Summary

14

5

5

(6-3+8-2)/(6+4+8+1)= 9/19=47%

Actual average GOS for A& B should be (10%+67%)/2= 38.5%

 

I ‘d like to create a graph to capture each day’s average GOS. For example, the table above represent one day’s data. I ‘d like to show this date’s average GOS- 38.5%  in the line graph. (The line graph need to show such data from the first working day of this month to current day.)

To get this 38.5%, it’s grouped by “Application”.

 

However the graph is grouped by  (on change of ) “Date” – so as to show the X Axis as the “Date” .

In the line graph, “show value” –  I put a formula as:  ( the result is GOS 47% which is wrong)

(sum({CallsAnswered}, {Application})-sum({CallsAnsAfterThreshold},{Application}))/sum({CallsAnswered}, {Application})+sum({CallsAbnAfterThreshold}, {Application})

 

Can any expert help me out and advise how to show each day’s average GOS  in line graph? Confused

 

Thank you very much.

 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.045 seconds.