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. ...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Microsoft Employee rankMicrosoft 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

    • PHK's avatar
      PHK
      Frequent Visitor
      9 years ago

      Hi v-huizhn-msft,

       

      yes that's it.

      The same field in row level and column level.

       

      So i'm waiting for an update :)

       

      Best Regards,

       

      PHK.

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

        Hi PHK,

        It's impossible to use one field to both row and column level(highlighted in yellow backgroud). For example [Add] field locates either Rows or Columns, we can not put it both of them.



        Best Regards,
        Angelia