Print Page | Close Window

Line Chart

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1323
Printed Date: 04 May 2024 at 6:28pm


Topic: Line Chart
Posted By: Caicai
Subject: Line Chart
Date 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.

 
 


Print Page | Close Window