How to produce a Cohort Analysis that shows existing and new customers contribution to the business carried along YoY. Objectives listed below.
1. Showcase year wise sales (in stacked bar graph) of existing and new customers by sales figures to see revenue contribution YoY.
2. Same in percentage wise.
I need to achieve this in front-end without having to work on the back-end script as this analysis has to be done by a business user who is not familiar with Scripting. The dimensions will also keep changing and hence looking for simple functions and logic which will help the user to achieve the same.