9 Replies Latest reply on Nov 16, 2011 9:45 AM by AlbertPujol

# chart from different fields of the same record

### Title

chart from different fields of the same record

### Post

Hello, I need some help in charting,

I'd like to display a line chart which would take the value from 8 different fields, from the same record.

The X axis would be each of those 8 fields.

The Y axis would be the same for them all obviously, which is a scale from -10 to 120.

I tried with calculations but can't get to it.

Thank you all for your help.

• ###### 1. Re: chart from different fields of the same record

The Y axis has to be a value, not just a scale.

Do you have a set of records to chart, each with your 8 different fields?

I think the Y axis would chart each of your 8 fields and your x axis will represent each record in your found set. A calculation you define in the chart set up can label these values by referring to other data in your table such as a date or category field...

• ###### 2. Re: chart from different fields of the same record

The Y axis must be the values introduced in each of the 8 fields.

The x axis must contain the labels of these 8 fields. I mean labels because the X axis never canges.

I got multiple records (patients) and 8 fields for each that take values from -10 to 120, but though ordinal fields, each field is independent from the others.

The line from the chart must link the value from these 8 values.

The calculation you mention I do not understand.

• ###### 3. Re: chart from different fields of the same record

So if you see 5 sets of 8 points charted, this is from 5 records from 5 different patients in your current found set?

• ###### 4. Re: chart from different fields of the same record

I attach an image to show what I mean.

• ###### 5. Re: chart from different fields of the same record
/files/0ea69e3eeb/Presentaci%C3%B3n1.jpg 960x720
• ###### 6. Re: chart from different fields of the same record

Ok, there's a Delimitted values option you can use.

Use the Specify calculation with:

List ( Field A ; Field B ; Field C ; Field D ; and so forth )

For the y-axis

Specify delimitted data in the Use data from drop down.

Ultimately, you may find it better to use a related table of records to record your 8 data points instead of 8 separate fields like this.

• ###### 7. Re: chart from different fields of the same record

I can't seem to reach it...

Though I List the fields in the Y axis, the chart displays no line.

Which would be the X axis? I had the title or name of each fiield...

I can't understand your second idea about a related table. Should I insert a real table?? is that possible?

I'm sorry to bother you so much. Thanks for your help anyway!!!

• ###### 8. Re: chart from different fields of the same record

For horizontal X axis, click Specify Calculation.

In the specify calculation dialog enter:

List ( 1 ; 2 ; 3 ; 4 ; 5 ; 6 ; 7 ; 8 )

If you don't want to number the points, put any labels you want in place of these numbers. If you use text, put them in quotes.

For Y axis, click Specify Calculation and enter this expression:

List ( Patients::Field 1;Patients::Field 2;Patients::Field 3;Patients::Field 4;Patients::Field 5;Patients::Field 6;Patients::Field 7;Patients::Field 8)

Note: you must have some value in every field as empty fields are omitted from the resulting list of delimitted values and this will misalign your data points and their associated labels. Put a zero in any of the 8 fields that are empty.

In the Use Data From Drop down, select "Current Record (delimitted data).

To use the related table I mentioned:

You can set up a new table linked by a Serial Number field in your current table (Patients?). You can use a portal to record the values. This, coincidentally, makes it possible to work with varying numbers of values, not just being limited to 8.

Then you can chart values by specifying the Use Data From: Related Records option to chart your data.

• ###### 9. Re: chart from different fields of the same record

Thanks!! Finnally I got it! Thanks so very much. Now I'll have to tweak the chart so that it ressembles the most to the standard audiometries.