This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I'm having trouble with my visualization that includes a 3-month moving average trend line. It's not displaying correctly when there's no data for a team during the months being viewed. Additionally, in visualizations where we compare two sets of data, if one has null values and the other doesn't, I get this error: "This regression analysis could not produce results. Trend lines cannot be drawn for horizontal lines, try a reference line instead."
Has anyone run into a similar issue or have suggestions on a better way to visualize this data to avoid these problems?
I am wondering if you might want to use a table calculation for the trend line instead? That way you can control how the nulls should be treated - rather than using the visualization's built-in Trendline option. This Community post about Calculating moving averages gives a good explanation about the difference, and examples. I hope that is helpful!
LinkedIn
Twitter
