AndrewJudd

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

Outcomes