I am trying to show some quoting metrics in a dashboard. The BAQ I created uses calculated fields to show sums per months. I am trying to show this graphically, but I am having issue with showing the months correctly in order.
I was trying to use a calculated field to show the year and month along the x-axis, but Epicor puts them in the wrong order because it is a string.
I tried to convert that field to a date format, but when I do it also adds the time 12:00:00AM at the end. This makes the month at the front get cut off on the chart, making the whole thing un-readable.