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?