2 Replies Latest reply on Jul 19, 2018 9:45 AM by jordi.torrecillascardona

    Percentage of total number of customers depending on percentage sales with status=1

    jordi.torrecillascardona

      Hi all!

       

      I have a complicated issue to solve, let me explain you correctly:

       

      1 - First I want to get percentage of sales with status=1 over the rest of status (if there is not status=1 then status 1=0%)

      2 - I want to create diferent levels depending on this percentages: (level 1 = % < 0,15, level 2 = % > 0,15)

      3 - I want to count the number of customers in each of this two levels and the percentage of total of this two levels

      4 - Create a pie chart with each o this levels

       

      This is the data, I attach that too: