6 Replies Latest reply: Nov 5, 2015 7:49 AM by Sunny Talwar RSS

    syntax set analysis

    Kilian Riera

      What i do wrong?

       

      this sentence is correct and it works. It grabs all the data (1) instead of using the selection ($), from all the facts matching groupID 3 and with an start time lower or equal to 01/11/2015 00:00:00 then it Sum it.

       

      Sum({1<GroupID={'3'},StartTime={'<=01/11/2015 00:00:00'}>}Valor)

       

      What i want to change is to make the 01/11/2015 00:00:00 automatic. i mean, put the current floor month start date. That way every new month i'll have the previous month data.

       

      But i've tryed a lot of things and none seems to work.

       

      Any Idea?

       

      huge thanks.