When assigning colours in charts to non-permanent series (e.g. series that refer to a temporary status of a DB item), the selected colour reverts back to the auto-selected one once the series reappears.
This creates big issues for us since we have lots of different statuses in our process which then start getting assigned random colours every time they reappear on the chart/dashboard. This makes it really hard to use since one has to closely inspect the legend which colour is what every single day.

Could we get some kind of feature to permanently assign colours to series even if they currently/sometimes do not appear in the chart?

Help would be appreciated a lot, thanks in advance!

A workaround to do this: write your query so that all status codes are returned on every execution, with a NULL for those not needed. The NULLs won’t appear in your visualization, but Redash will remember the color you choose.

Here are three executions of the same query.