Forum Discussion

PHK's avatar
PHK
Frequent Visitor
9 years ago

How to design an Attrition Matrix ?

Hi everyone,

 

I'm trying to mesure the rate of attrition of my customers, but it's quite complex to me.

 

In my data, the customer bought an article with an starting and ending release number.

Basicely I have two tables :

        - Orders with : CustomerID, Starting Number, Ending Number.

        - Release Number with : Release number and release date.

 

I want to know for each release number the attrition of my customers and I want to design something like this :

 

Release NumbersSubcriptions789101112131415
7150150148140135120100989895
8200 200180150145120857545
920  20191818171512
1015   15108700
1116    1615131211
1217     17151311
13155      1559555

 

Is that possible ? 

 

Thanks

 

PHK

Need Help

5 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi PHK,

    I am not sure if it is possible, because I am still confusing, how do you get the right part of the expected table? For example, how to get 148 for 8, 140 9? And in the table, Release Numbers list in rows as well as columns? Please share more details for further analysis?

    Best Regards,
    Angelia

    • PHK's avatar
      PHK
      Frequent Visitor
      9 years ago

      Hi v-huizhn-msft

       

      For the Release Number 8, I have 150 subscriptions (Start Number), and for the Release Number 9 I have 2 cancellations (Ending Number) , so I have for the Realase Number 9  148 remaining subscriptions. 

       

      My y-axis show me the release number and the amount of subscriptions, and my x-axis the remaining subscriptions.

       

      Tell me if it's not clear.

       

      Best Regards,

       

      PHK.

       

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi PHK,

        Based on my understanding, if 7,8,9,10,11,12 and 13 are in same fields in your resouce table. You want to dispaly it both row and column in a visualization, it's impossible. One field only show in row level or column level.

        Best Regards,
        Angelia