Hi, I'm having trouble with matching colors between two pie charts on the same dashboard.
The issue is that I would like both charts to use the same colors for the same label names ("books", "crm_and_desk", etc), but I'm not able to do so neither using the very same column label as reference for the color nor sorting values in alphabetical order.
Take labels "books_and_crm" and simply "crm": they have the same color, even though that's not the expected behavior.
The reason for that is that not all labels appear in both charts, so name sequence does not match.
Any ideas on how to escape from that besides adding dummy rows in my tables so that the missing labels now appear in both charts?