AnsweredAssumed Answered

Graph problems

Question asked by carlsson on Jul 21, 2017
Latest reply on Jul 21, 2017 by jbrown

I have worked with Filemaker a long time, but I still have problems with graphs. Maybe I'm overthinking it. The thing is that I never get the results I want. I have read FM's instructions, and I have searched the web for information, but I still don't get it.

Could someone please point me the right direction I would be very happy!

 

Example:

Two tables: Client and Order

Mission: Create a graph that shows how many orders that have been sold from period A to B.

 

This sounds really easy right? But I just can't get it to work.

 

I do get a graph, but it's not what I want. Attached is a screen capture of the Chart Setup (in FM14, I can't use FM16, it crashes in the Chart Setup window).

 

Some questions:

1. The X axis is a blur of dates, I'd rather see months. Is it possible to do that directly in the Chart Setup, or do I have to do separate fields for this?

2. Same for Quantity (Y Axis), I'd like to see it per month as well.

3. I am creating the graph in the Client view, because I want to see a small graph when I open the Client card. Thus, I think that the Data Source > Chart Data must be set to Related Records. Correct?

 

Any suggestions?

Outcomes