Forum Discussion
Resolver IMissing Trend Line and Forecast options in Analytics
In the Line Graph depicted by Alicia_Anderson , three values are being displayed (3 lines). The Trend line will only be available if you have a single line depicted in the graph. Otherwise, the Trend algorithm does not know which of the three to use in showing trend or how you might want to combine the existing three lines to show trend (sum, average, ??). The visualization is currently limited to showing trend for a single line.
Community SupportHi Alicia_Anderson,
Do you have a date field on the Axis? Forecast will only appear when using a date there.
Regards,
Frank
- v-frfei-msft
Hi Alicia_Anderson,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Alicia_AndersonThe X axis displays a Sprint, which equates to a 2 week period. I don't want the X axis to be a date, but I changed it to one to see if the Trend and Forecast options displayed but it still did not.
I'm having the same issue. I'm using a Line chart and my X-Axis has fiscal weeks (WK01, WK02, ...) and would like to keep it that way.
Thank you for the comment. I change the axis value to date Hierarchy, expand to the timeline I need, and the Trend Line option appears!
Thank you,
I'm having a similar issue, but I think it's because my dates are weekly, not daily. The trend line is in the analysis bar for me to create, but it's now showing up. Wondering if it's because of the gaps in my dates. We only track this thing once a week.