Sort on Report Chart

Question

Hi 
 have setup a view which gives a breakdown of orders per month, struggling to get it sort on the month name or no: any ideas?

Matthew Shaw · Accepted Answer

Is this what you're after? The bars are the 'Rate Value' and the line is the 'Rate Count'. If so the script is the same as your, but as mentioned the issue is with the date values, you have stripped them back to just being numbers and not not meaning much to CRM. In mine I have kept them as dates - but set them all the 1st of the month and then grouped that way, CRM then recognises them as date values (I have only done previous year only because of the data in my test system) (Looking at the graph I might have got my columns and lines the wrong way around - bars look to be the % rate and the line is the value)

Sage CRM

Sort on Report Chart

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING