Forum Discussion

ivandelgra's avatar
ivandelgra
Icon for Helper I rankHelper I
6 years ago

How to count attribute changes in data set and then compare them YoY

Hello I have this dataset:

 

ID PERSONCARD TYPESUBSCRIPTION YEAR
AFREE2018
APREMIUM2019
BPREMIUM2018
BPRO2019
CFREE2018
CPRO2019
DFREE2018
DPRO2019

 

I would like to know for each year (e.g. 2018 vs 2019) how many subscribers have changed their plan (grouped by subcription plan).

 

Below an example of the desired output (of course it would be ok any kind of other visualizations showing the same result)

 

 

Need Help

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi ivandelgra , 

    It seems that there is no visual is like your expected output, and it seems that your result will based on previous year . I  have no idea about this currently, and I just get result like below

    I think I need to discuss this with other people, and I will inform you as soon as I get it.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ivandelgra's avatar
      ivandelgra
      Icon for Helper I rankHelper I
      6 years ago

      In some posts I have read about EARLIER capability. Is this a case in which EARLIER function can help?