2 Replies Latest reply: Apr 12, 2017 7:31 AM by omar bensalem RSS

    KPI with date variable

    Andrea Giacomello

      Hi experts!

      I have this problem: I have a slider that set a DateVariable (VariableDate) defined like (=today()).

      I need to show that variable with a KPI, and i simply added one formatted as Date with the expression =(VariableDate). (until this point everything ok)

       

      I need also to set a kpi that shows the average of a field before the date i set with the slider. The expression I used is this one:

      Avg({<FieldDate={'<=$(DateVariable)'}>} MyField)   but it does not show anything.

       

      Anyone can help me?

      Thankyou!