6 Replies Latest reply: Aug 2, 2016 7:46 AM by Marc van der Peet RSS

    Get a count from values between a certain range

    Marc van der Peet

      Dear all,

       

      I have the following data that I would like to load

      LOAD * INLINE [
      DATE, WEEKIN
      2012-02-02, 2
      2012-02-02, 3
      2012-02-02, 4
      2012-02-04, 4
      2012-02-06, 6
      ]
      ;

      And I have set the following variables:

       

       

       

      set vDate1 = "2012-02-02";
      set vDate2 = "2012-02-04";

       

      I would  like to create a graph that shows the count of the values between date1 and date2. So therefore I created a graph with the following expression

       

      count(<DATE={'>=$(vDate1) <=$vDate2)'}>}[WEEKIN]

       

      But this gives me an error. Any thoughts on where I go wrong?