Column Chart Months

Discussion created by AndrewJudd on May 3, 2016
Latest reply on May 4, 2016 by AndrewJudd

hi all, this is probably a classic question but I haven't seen a solution online yet. I'm making a straightforward chart export that displays


a summary field called INVOICES::s_Invoice GBP Total along the Y axis,


and this along the X axis -


Left ( MonthName ( INVOICES::INVOICE DATE ) ; 3 ) & " " & Year ( INVOICES::INVOICE DATE )


Attached is an example result. As you can see  Jun 2016 is displayed twice (as there are two invoices made in June in the foundset).


How do I group these totals into month? Do I need to implement another summary field that runs from a calculation field by month and have that along the bottom or does this need scripting. I'll attach my script so far.


Thanks all!



Screen Shot 2016-05-03 at 22.56.27.png




Screen Shot 2016-05-03 at 22.57.20.png