I have a simple data model recording accidents per month and want to create a bar graph showing month accidents and a running total.
Normally this wouldn't be an issue but our Accidents data uses a start month of May i have a custom column to give a value of 1 to May, 2 to June etc. If i create the acumulative total on this value everything works fine:
However i'd rather show the month names rather than number. If i chage the axis the date changes and only shows the actual figure:
The month Name isn't a numerical fielf for me to use in the accumulation calulation. Is there a way to do this?