2 Replies Latest reply: Mar 5, 2013 8:03 AM by Saumya Shah RSS

    calendar date(Start Date and End date) problem

    Saumya Shah

      What to write in expression for date condition if expression has three if conditions

      =if(Avg(Metric_value)>=[Threshold-Red],'qmem://<bundled>/Buletin/led_r.png',

      if(Avg(Metric_value)>=[Threshold-Amber],'qmem://<bundled>/Buletin/led_y.png',

      if(Avg(Metric_value)>=[Threshold-Green],'qmem://<bundled>/Buletin/led_g.png','qmem://<bundled>/Buletin/cross.png')))

       

      i have date condition

      =Avg({<Date={'>=$(Start_Date)<=$(End_Date)'}>}Metric_Value)

       

      how can i use it for three if conditions