Chart will not summarize/group by month...

[Darren Emery]

I'm stumped and any help would be greatly appreciated.  Image of chart and pertinent settings below.  My goal is to group and count the number of inspections by month, bu they all are reporting as individual columns on the graph, rather than being grouped as desired. I feel like I'm close, as the correct data is displaying, just not summarizing correctly.  

I am working on a small found set of inspections, and have sorted the 54 resulting records by the field _get_month_name, and I have a field set as summary to count the number of records (count of primary ID on inspection). 

Body part is a Sub-summary when sorted by _get_month_name

 

 

[comment]

I don't think it's possible to reproduce the problem from your screenshots. See if the attached file works as you would expect.

 

ChartByMonth.fmp12

[Darren Emery]

comment - yes your file represents just what I'm trying to do.  I will dig in and see if I can find the issue with my file.  I sincerely thank you  - I have not been active on the forum for a couple of years, but will be back a lot going forward, and have always appreciated your input!

[comment]

P.S. Note that months with no inspections will be skipped.

 

[Darren Emery]

 

On 4/24/2022 at 9:14 AM, comment said:

P.S. Note that months with no inspections will be skipped.

 

That makes sense - thanks.

Your file has been VERY helpful.  Not quite sure what's going on with the cMonth field though: 

Date - Day ( Date ) + 1

 

How does that calculation return the Month? 🤔

 

 

 

 

[comment]

2 hours ago, Darren Emery said:

Not quite sure what's going on with the cMonth field though: 

Date - Day ( Date ) + 1

 

How does that calculation return the Month? 🤔

It doesn't. It returns the date of the first day in the month of Date. This is convenient because sorting by this field preserves the chronological order while still grouping by the month. Thus issues like sorting by month name in non-alphabetical order or sorting across year boundaries are eliminated. OTOH, the resulting date is easily formatted to display as month/year only - as you can observe both on the layout and within the chart.

 

[Darren Emery]

Quick follow up - got the chart working perfectly, thanks to your tremendous help, comment.  Thanks so much!