Chart Status By Month and Year

[AnthonyDixon]

Hi Everyone,

I’m trying to chart the open and closed status of my orders by month and year
for a given date range but I’m doing something wrong. I have the chart breaking
down by month and year ok but my totals are showing the same for all months and
years. Am I missing something obvious? See attached

Using FM 12 Adv Win/Mac

 

Thanks

Anthony
 

ChartMonthlyStatusRelated.zip

[voltron2112]

I'm not great at charts so there might be an easier way, but this is how I did it. 

 

I got rid of your 2 extra data tables, and instead added 2 summary fields. One that counts the Open and one that counts the Closed. To get these counts you need a field that I named BoolOpen and BoolClosed that puts a one in the field if the status is open or closed, then the 2 summary fields just sum up those 2 new fields. I updated your file so you can see exactly what I mean.

 

If anyone has a better solution I'd love to see it! 

ChartMonthlyStatusRelated.zip

[AnthonyDixon]

Thank You! I think I tried something like this but could not get it to work quite right.

 

This works for me, I do wish I could accomplish this without adding additional fields

 

as my table is already crowded enough.

 

Thanks again for your help.