Charting specific data only

[gardenlevel]

I couldn't decide if this belonged here or under scripting, but decided to go with this since others may want the same info.

I think this is fairly easy, but I can't quite get it.

I want to chart a calculation so here's an example:

X - Date Field

Y - Dollar Amount Field, but only where Owner Field is =1

This way I can have a separate Y line for each "owner".

[SavvyData]

Hi "Gar",

Sure -- you can have up to 12 separate lines on a line chart. You just have to add them one at a time as a separate series, by clicking the "+" sign beneath the "Vertical (Y) Axis" area in the Chart Setup dialog box.

Cheers,

-Lee

[Lee Smith]

Hi Garden Level,

What version of FileMaker are you using?

If you have upgraded to 11, please update your profile. This link will explain how to do this. Update Profile

Lee

[JerrySalem]

AFAIK

You will also need a separate relationship for each line on the graph

Something like

date_INV_Owner1::totBalance

date_INV_Owner2::totBalance

hope this helps