Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts.. This is bit tricky and am not able to find it.. Hope it will be simple for u guys..
Here is the scenario..
My Expression is
sum({<Date = , Month = ,AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000
In the above expression, i have included ("Date = , Month = ").. So now i get the output accordingly..i.e., if i select Date or month, i dont see it is getting reflected in my chart...
Next is i have added Background color expression also... it is like below
if (Aging_Bucket1 = '>365' , RGB(255,0,0),
if (Aging_Bucket1 = '181-365', RGB(250,70,70),
if (Aging_Bucket1 = '91-180', RGB(252,115,98),
if (Aging_Bucket = '>90' , RGB(255,0,0),
if (Aging_Bucket1 = '61-90' or Aging_Bucket = '61-90', RGB(255,255,0),
if (Aging_Bucket1 = '31-60' or Aging_Bucket = '31-60', RGB(77,167,65),
if (Aging_Bucket1 = '0-30' or Aging_Bucket = '0-30', RGB(77,200,65))))))))
Now the issue is... in my dashboard, i have a default date selection to the latest date.. in my chart i have date as dimension.. since latest date is selected.. only for the latest date, the above color coding works.. i need this to apply the color coding expression for all the bars irrespective of if the latest date is been selected.. How do i now apply the same logic which i used in my expression ("Date = , Month = ") in my background color expression as well??
he is how i see the chart now..
Below snapshot week will be selected by default in my dashboard
Try putting only() around your expression like:
Only( {<Date, Month>} Your expression )
Try putting only() around your expression like:
Only( {<Date, Month>} Your expression )
Perfect!! good to know how to use Only() TY!!