Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Trouble with Null Values Affecting Trend Lines in Looker Explorer

Screenshot 2024-06-25 at 15.55.50.pngI'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?

0 1 580
1 REPLY 1
Top Labels in this Space
Top Solution Authors