2 Replies Latest reply on Nov 18, 2019 4:26 AM by akash manakshe

    Customer BIN Movements Daily

    Willium Fox

      Hello there Experts,

       

      I have came up with the below stated issue.

       

      I have a customer set which have segmented accordingly to their behavior. As an example if the customer's purchasing, spend pattern, repayment is good, the customer will be segmented in to six Bins. such as

      Segment A, Segment B, Segment C, Segment D, Segment E  and Segment F. This changes daily and continues.

       

      What I need is a summary to identify how many customers moved from Segment A to Segment E, Segment E to Segment  B  and etc within the month like wise.

       

      Please refer the attached excel for your references and thank you very much.

       

      Expecting the tableau calculations and the method of getting this done.

       

      Thank you very much