2 Replies Latest reply on Aug 6, 2018 6:48 AM by melaniedddd

    Count distinct id on MQT


      Hi everybody,


      I currently want to count distinct id on moving periods. I've tried different way to have the good result, but I have an issue : the result of my countd is the sum of each month while some id are in the database every month (see chart below).

      Does someone know how to do reach my goal ? I tried to use a fixed formula but doesn't work with a window calculation.


      MQT countd501049585100
      MQT countd expected195019102100


      Many thanks !

      Best regards,