Hi team,
i have created 2 table of in one explore view and put it in one dashboard, but the legend are not same color. are there any way to make them interact each order like other BI tools
Hi there!
Colors are assigned to each series in order. As long as the results are ordered the same for both queries the colors should align correctly.
Let me know if that works for you and please do not hesitate to follow up!
Another way to make sure that your data is always ordered the same, and therefore maintains the same color assignment in the legend, would be to create a derived table with a derived column for rank. Here is an example:
Depending on the data that you are working with you may be able to come up with a similar solution. Hopefully this helps!