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

    Count distinct id on MQT

    melaniedddd

      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.

       

      janv-18févr-18mars-18
      Countd200014001700
      MQT countd501049585100
      MQT countd expected195019102100

       

      Many thanks !

      Best regards,

       

      Mélanie