how to set specific colors to 3 pie charts trellis with 4 dynamic labels ?

[10Q]

Hi,

I'm trying to set a specific color to each one of 4 my dynamic labels of my 3 trellis pie charts.

I already added series color option :  <option name="charting.seriesColors">[#CFD6EA,#C45AB3,#735CDD,#8fba38]</option>

My issue is that my labels are "dynamic" and also  I don't  have a constant  number of categories ( it changes in each chart between 0-4 according to the data i receive).

So my color plate sequence not aligned with the number of categories.

For example, I want to set the flowing:

type_A - Red

type_B- Blue

type_C- Green

The problem is that  sometimes category "type_A" is missing from one or more of my charts and the category type_B is getting its color (Red) instead of Blue.

here is my query:

<---Search-->

| stats dc(sessions) as Number_of_Sessions by type
| sort type
| eval type = type." - ".Number_of_Sessions

I will very a appreciate any help i get get :-0)

10Q