Single Axis Graph

[patryn150]

I've been tasked with charting out responses for a survey of ours. One of the charts that I need to so is to plot out 2 single points of data on a scale of 1 - 10. I've searched through the topics here to see if any one has posted anything similarly and I cannot find anyone who has.

Can anyone give me any insight as to how to accomplish this?

Crystal Reports XI
DB: MSSQL

Thanks!

 

[Turkbear]

Hi,
Can you further explain how graphing only 2 values would work?
Or do you mean 2 sets of data that can have responses of from 1 to 10?

Did you check the built-in graphs in CR, like Line and Area?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Are the two points from the same field? If so, what is the other field that distinguishes the values, i.e., does your data look like this?

ID Value
A 5
B 10

-LB

 

[patryn150]

What I'm ultimately trying to do is something like this (sorry for my horribad design in text)

ID Value
A 4.5
B 7.67


A B
|---|---|---|---|---|---|---|---|---|
1 2 3 4 5 6 7 8 9 10


Looking at Line/Scatter, from the work I've had with them, scatter makes one axis = ID A, the other axis = ID B. Line graph builds vertically instead of horizontally, which is what I'm trying to accomplish (horizontal).

The two points are running totals that evaluate an average based upon which question it is.

Hopefully this info helps a bit more!

Thanks!

 

[lbass]

So is it one running total that resets on change of ID or two running totals?

-LB

 

[patryn150]

Two separate running totals. The report is grouped like this:

UniqueCallID1
Question 1: Answer
Question 2: Answer
End Group

UniqueCallID2
Question 1: Answer
Question 2: Answer
End Group
...

The running totals only evaluate on their proper question, so:

Running Total#1 = Average response of Question 1
Running Total#2 = Average response of Question 2

Neither RT resets in the report. The overall chart that I'm trying to have will be in the report footer.

Thanks!

 

[lbass]

Okay, first create a formula {@all}:

whilereadingrecords;
""

In the chart expert->type tab, select the "line chart with markers at data points" and choose "horizontal." Then add {@all} as your "on change of" field, and then add each running total as a summary.

-LB

 

[patryn150]

Sweet, that works! Thank you for your help.