Forecast Analytics - not available when x-axis contain fiscal year and months

[ian_coetzer]

Good day

How can I enable forecasting analytics (ETS) when using my fiscal year-month axis labels?

I know that forecasting can only be enabled on a - date type - but I need to display my data over fiscal year and month names - as per the image below.

If you have any ideas that may help me in this scenario please let me know.

[Icey]

Hi @ian_coetzer ,

How about conbaining your fiscal year and month into one column, and setting this column's type as "Date"? Then just do the same as your calendar date column in the chart.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.