4 Replies Latest reply on Sep 19, 2016 1:06 PM by Burak Tansug

    Calculating number of times a cell is populated

    Burak Tansug

      Hi,

      In the attached .twbx file, 2 customers' monthly revenue is shown for 36 months in a time-series data.

      What I am trying to do is to get the count of months where the customer has revenue.

       

      The first customer (Customer ID: 0000A123) had revenue in 33 months out of 36.

      The second customer (Customer ID: 0000B177) had revenue in 30 months out of 36.

       

      So, what I am trying to do is to put these counts (33 and 30) as a separate column, next to Cust ID.

       

      I believe this needs an LOD calculation, but I could not figure it out.

       

      Any help is greatly appreciated.

       

      Thanks

      Burak