Consistent chart series colour - fuzzy match
I have multiple series in a scatterplot chart. Each series is based on combination of two fields - product name and one or many associated dispenser numbers. End result is like: "Product A - 1,2" or "Product B - 3".
Charts don't allow multiple fields in the Colour section, so to create a series label I have to combine these fields into a single value (calc field or in DB query).
I have setup Org reference codes for product name to display them as consistent colours in charts. The issue here is that the addition of the dispenser number to the series label means that the org reference codes will not match.
For my situation there can be numerous combinations of product and dispenser number, so approx 500 combinations across 10+ products. I could generate these and load via CSV, but it would be nice to have either:
- flexible ref codes (wildcards, regex) to do partial matches
- separate fields for series (label) and colour in charts