to calculate the Product Volume Trend chart. I have Product and Week End Date in the Dimension.
For my master selection, I have Agg Time Frame Filter which is not applicable for this trend chart.
The Numbers and Calulations which I am getting is very fine.
But when I am writing an expression to change the color of trend lines in the Background Color:
Expression:
if
(Product=1, RGB(51,51,153),
if(Product=2, RGB(150,61,59),
if(Product=3, RGB(121,146,68),
if(Product=4, RGB(119,93,151),
if(Product=5, RGB(243,150,183),
if(Product=6, RGB(254,186,18),
if(Product=7, RGB(121,151,197),
if(Product=8, RGB(96,74,125),
if(Product=9, RGB(0,136,159),
if(Product=10,RGB(210,151,106)
) ) ) ) ) ) ) ) ) )
When Timeframe is not selected the colors are shown in the trend chart but as soon as Timeframe gets selected the color code do not apply. It takes the default color.