Why are my series colors and other visualization settings randomly changing?

Knowledge Drop

Last tested: May 6, 2020
 

Is it a pivoted query? If so, it could be a case of “When the clock strikes midnight the visualizations come alive with a mind of their own.”

The series editor is based around the pivot value of the series, so any visualization settings you have set on the pivoted series (colors, vis type, y-axis settings, etc.) will revert to default settings if those pivot values change. That is, when the pivot values returned by the query change based on new data, different filters, etc., the saved vis settings on the original pivot values will not be carried over to the new pivot values.

Although this behaviour can be confusing, it is intended functionality, so you can go ahead and add your vote for this feature request if you are thrown off by this behaviour. The workaround is to turn the pivoted series into table calcs using pivot_index() to make sure the series names never change.

This content is subject to limited support.                

Comments

This feature request more accurately describes the desired behavior from this article: https://portal.feedback.us.pendo.io/app/#/case/77718

alexsunny123
New Member

Thanks for the awesome information.

Version history
Last update:
‎07-07-2021 01:51 PM
Updated by: