Jump to content

Chart Status By Month and Year


AnthonyDixon
 Share

This topic is 2834 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2834 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.