AnsweredAssumed Answered

Chart by Month HELP!

Question asked by warfadoc on Jan 7, 2018
Latest reply on Jan 8, 2018 by philmodjunk

I need help on a graph, I have searched and have found some solutions that average sales per month but I needed something different.  I have a date field this field is called procedure_date, ie the day a procedure was done.  There are several procedures I do, but we can use fruits as an example, there are apples, oranges, bananas, grapes... When charting I want to break down over several months Jan/Feb/March how many apples vs oranges vs bananas where sold (or in procedure terms done).  I am only able to get a total count of all the procedures done in a month,.  The graph I need would have on the x axis the month, with 4 bars one for each fruit (procedure) for each month so Jan 4 bars, feb 4 bars comparing how many of each where done per month.  I now have a variable called cMonth which grouped individual dates into months, but I don't know how to now use cMonth and get a chart as described above.

 

Any help or pointer would be appreciated

Outcomes