Has anyone ever had issue with months not being in right order on X axis in bar chart? I created a custom formula just so I could Order in my card but for some reason March is showing after November on X axis. When I look at datamart all March records have a 3 so dont understand why March is out of order. Any thoughts would be greatly appreciated!
CASE WHEN MonthName
= 'January' THEN '1'
WHEN MonthName
= 'February' THEN '2'
WHEN MonthName
= 'March' THEN '3'
WHEN MonthName
= 'April' THEN '4'
WHEN MonthName
= 'May' THEN '5'
WHEN MonthName
= 'June' THEN '6'
WHEN MonthName
= 'July' THEN '7'
WHEN MonthName
= 'August' THEN '8'
WHEN MonthName
= 'September' THEN '9'
WHEN MonthName
= 'October' THEN '10'
WHEN MonthName
= 'November' THEN '11'
WHEN MonthName
= 'December' THEN '12'
ELSE '' END