AnsweredAssumed Answered

Graphing by Month

Question asked by deanchampeau on Jan 12, 2018
Latest reply on Jan 13, 2018 by beverly



I'm fairly new to graphing, and I'm having difficulty setting up a graph to display the number of orders per month for a given found set. I'm using an auto-enter monthOfOrder field as my X axis, and a summary field based on Count as my Y axis. It works as you would expect, but the problem is that sometimes my found set has zero records for a particular month. So for those months, my graph doesn't display a bar because there's no data to display.


How do I get FileMaker's graphing to display every month, even if the number of records associated with some months is zero?


Thanks in advance.