Able to replicate this

• I believe the chart must be grouped by at least 1 dimension and one of the dimensions referenced on the grouped series needs to be used as a filter

Local link: http://localhost:3000/projects/3675b69e-8324-4110-bdca-059031aa8da3/tables/orders?create_saved_chart_version={"tableName":"orders","metricQuery":{"exploreName":"","dimensions":["orders_order_id","orders_status","orders_is_completed","orders_order_date_day"],"metrics":["orders_average_order_size","customers_unique_customer_count"],"filters":{"dimensions":{"id":"226a3351-9d37-49fe-9518-23afce36f83c","and":[{"id":"f8bfeab1-ad54-4c2c-9c86-d225088d19f9","target":{"fieldId":"orders_status"},"operator":"equals","values":[],"required":false}]}},"sorts":[{"fieldId":"orders_average_order_size","descending":true}],"limit":500,"tableCalculations":[],"additionalMetrics":[]},"pivotConfig":{"columns":["orders_status","orders_is_completed"]},"tableConfig":{"columnOrder":["orders_order_id","orders_status","orders_is_completed","orders_order_date_day","orders_average_order_size","customers_unique_customer_count"]},"chartConfig":{"type":"cartesian","config":{"layout":{"xField":"orders_order_id","yField":["orders_average_order_size","customers_unique_customer_count"]},"eChartsConfig":{"series":[{"type":"bar","yAxisIndex":1,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"customers_unique_customer_count","pivotValues":[{"field":"orders_status","value":"returned"},{"field":"orders_is_completed","value":false}]}},"color":"#0d2e1f"},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"customers_unique_customer_count","pivotValues":[{"field":"orders_status","value":"placed"},{"field":"orders_is_completed","value":false}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"customers_unique_customer_count","pivotValues":[{"field":"orders_status","value":"shipped"},{"field":"orders_is_completed","value":false}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"customers_unique_customer_count","pivotValues":[{"field":"orders_status","value":"return_pending"},{"field":"orders_is_completed","value":false}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"customers_unique_customer_count","pivotValues":[{"field":"orders_status","value":"completed"},{"field":"orders_is_completed","value":true}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"orders_average_order_size","pivotValues":[{"field":"orders_status","value":"returned"},{"field":"orders_is_completed","value":false}]}},"color":"#e00000"},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"orders_average_order_size","pivotValues":[{"field":"orders_status","value":"placed"},{"field":"orders_is_completed","value":false}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"orders_average_order_size","pivotValues":[{"field":"orders_status","value":"shipped"},{"field":"orders_is_completed","value":false}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"orders_average_order_size","pivotValues":[{"field":"orders_status","value":"return_pending"},{"field":"orders_is_completed","value":false}]}}},{"type":"bar","yAxisIndex":0,"encode":{"xRef":{"field":"orders_order_id"},"yRef":{"field":"orders_average_order_size","pivotValues":[{"field":"orders_status","value":"completed"},{"field":"orders_is_completed","value":true}]}}}]},"metadata":{"orders_average_order_size_n2.placed.false":{"color":"#71bfeb"},"orders_average_order_size_n2.shipped.false":{"color":"#d4a7d9"},"orders_average_order_size_n2.returned.false":{"color":"#e00000"},"orders_average_order_size_n2.return_pending.false":{"color":"#ff6666"},"customers_unique_customer_count_n2.shipped.false":{"color":"#f5fcff"},"customers_unique_customer_count_n2.returned.false":{"color":"#0d2e1f"},"customers_unique_customer_count_n2.return_pending.false":{"color":"#8bbf71"}}}}}

On the main issue represented by the video from the Slack issue, it seems that the filter affected the series values.

We could be smarter with the Type, Axis, and Value labels and keep them intact (as well as the order) when there's a behaviour like this.

EDIT

It's quite tricky to pinpoint what is causing this issue.

I just tested another similar scenario and it seems right to me - the colours for each series remain intact after applying a filter

See playlist_deleted low

before

after

@TuringLovesDeathMetal @joaoviana This happens when the pivot (grouped by) values change.

Demo:
(this can be replicated with a single metric in the y axis but is easier to understand with 2 as the pivot values are part of the series name)

Context:

• we generate a unique reference and a series for each combination of the pivot value and the y axis metric
• series groups and their configuration are extrapolated from the series. They are not saved in the database.

Example:
If in the first query we have the series:

• placed average order size
• completed average order size
• placed completed order count
• completed completed order count

On the second query we have the series:

• return_pending average order size
• returned average order size
• return_pending completed order count
• returned completed order count

Since the series references are different, we don't keep any configuration.

series groups and their configuration are extrapolated from the series. They are not saved in the database.

I believe this is the root problem. Users expect the settings for that group ( aka y-axis metric ) to be saved but it's not. At the moment, when the user updates that config we are updating all the series that belong to that group.

We could save the Type, Axis, Value labels, Show symbol, Smooth. The new series would still have different colours.

One Q on the example @ZeRego , if you revert the filter back to placed completed, do you get the previous colours back?

@joaoviana Yes. We recently started to store series colours so we know the color of a series that reappears. They are stored in CartesianChart['metadata']