Custom Color By Dynamic Dimension

[arvindjha2050]

Hello Team,

I have a below situation.

Dimension : Last 8 quarters

Measure : Total Sales

I would like to have custom colors(By expression) for my last 7 quarters.

The last 7 quarters will be dynamic as per Today's date.

For instance as of today's date , quarter will start from 1st January 2017.

So Q1-2017 will have a rgb(),

Q2-2017 will have different rgb value so on and so forth

Thanks & Regards,

Arvind

[vishweshwarisun]

hi,

In the custom colour expression you will have to write the if Condition

=If(Quarter='Q1',rgb(),

If(Quarter='Q2',rgb())) an so on

[prashantsanchet]

Hi,

What is the field name of Dimension for Quarter and what are the values inside it ?

Does it calculated dimension ?

Regards,

Prashant

[arvindjha2050]

Hello Sunketa,

The Quarter is not fixed, last 8 quarters will continuously change with time hence we cannot put static values, hence this will not work.

Thanks

[arvindjha2050]

Hello Prashant,

Yes it's a calculated dimension.

'FY'& fYear&'-'&FQuarter

Thanks

[arvindjha2050]

The values are like :

FY2017-Q2

[Anil_Babu_Samineni]

For sure it is possible to use Master Items with custom colors for last 8 Quarters.

[balabhaskarqlik]

May be you can add one more dimension or measure.

After that, try an expression like:

Count({$<Cust_Lost={"1"}>} distinct Customer)