I have created a WebPart Chart extracting data from a list. Within the list there is a calucated field, that when the chart is generated it will show fields for year and month in order.
Formula used:
=YEAR([Date Inspected])
&"-"
&CHOOSE(MONTH(DATEVALUE(MONTH([Date Inspected])
&"/"
&YEAR([Date Inspected])
)
)
,"01. January"
,"02. February"
,"03. March"
,"04. April"
,"05. May"
,"06. June"
,"07. July"
,"08. August"
,"09. September"
,"10. October"
,"11. November"
,"12. December"
)
The first entry in the list was July 2014. So the field generates "2014-07. July". Now everything after June 2015 is not appearing on the chart.
Does anyone has suggestions on how to change the formula to get my data to appear or to change something within the WebPart ezEdit?