5 Replies Latest reply on May 14, 2018 4:40 AM by Zhouyi Zhang

    Changing customer-Status month-by-month (LOD?)

    Franz Duge

      Dear Tableau-Community,


      I want to see how many active / inactive customers I have per month? Sounds simple – I thought. But I cannot show this in Tableau.

      Could anyone help? I have no idea to solve this problem (... and I read a lot of LOD and some other things to find a solution )


      Here is what I want to create:


      Definition of "active" and "inactive":

      month(Last Order) + 12 > column heading

      AND month(First Order) <= column heading

      --> active else inactive


      I started a thread 2 weeks ago (Monthly-based analytics from user-status ). The answers were very good but couldn't help me.