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

    Calculating number of times a cell is populated

    Burak Tansug


      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.