How to design an Attrition Matrix ?

[PHK]

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 Numbers	Subcriptions	7	8	9	10	11	12	13	14	15
7	150	150	148	140	135	120	100	98	98	95
8	200		200	180	150	145	120	85	75	45
9	20			20	19	18	18	17	15	12
10	15				15	10	8	7	0	0
11	16					16	15	13	12	11
12	17						17	15	13	11
13	155							155	95	55

Is that possible ? 

Thanks

PHK

[v-huizhn-msft]

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]

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]

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]

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]

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