Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
What is the field name of Dimension for Quarter and what are the values inside it ?
Does it calculated dimension ?
Regards,
Prashant
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
Hello Prashant,
Yes it's a calculated dimension.
'FY'& fYear&'-'&FQuarter
Thanks
The values are like :
FY2017-Q2
For sure it is possible to use Master Items with custom colors for last 8 Quarters.
May be you can add one more dimension or measure.
After that, try an expression like:
Count({$<Cust_Lost={"1"}>} distinct Customer)