Multi-Column Chart not showing one set of columns
I am trying to put together a chart in FM12 that uses multiple columns. The X-Axis is year, the Y-Axis is a count of people. One set of columns show the number of people entering a program (EntryDate is not null, CertDate is Null) and the second set of columns show those getting Certified (CertDate is not Null).
If I display the chart as individual data all the data point show. However if I display the chart as a summary by year only one set of columns shows (People Entering), the other columns are missing.
So the data is in the found set, but I just can not get it to show a summary with two sets of columns. Does anyone have any suggestions as to where to look for the solution?