3 Replies Latest reply: Oct 2, 2012 5:44 AM by Tobias Klug RSS

    set analysis fieldvalue in certain time range

    Tobias Klug
      Hello,
      I am struggling using the set analysis in order to count only fieldvalues that fall into a specified time range. Two variables are used Test_Start and Test_End. They define the time range.
      The following formula does not work. The time range will be ignored:
      count(  {< datereported = {">=$(Test_Start)"},  datereported = {"<=$(Test_End)"}>} ID)
      Using only one variable works just fine:

      count(  {< datereported = {">=$(Test_Start)"} >} ID)

       

      Can anybody give me a hint why the combination of Start and End does not work?

       

      Thanks for your help!