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!
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).
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?