1 Reply Latest reply: Sep 14, 2011 7:10 PM by Daniel Rozental RSS

    Number Merchants 80% Sales

      Hi,

       

      I would like to see the number of merchants responsible for 80% of revenue over time. The idea is to see which proportion of our customers provide 80 percent of our revenue and how this figure evolves over time. There are numerous posts dealing with this topic, but so far I have been unable to get them to work in my context.

       

      So far, I've used the fractile function to create a limit over which I want to see the count of customers. Then I use a count/if conditional statement to query the count, but this is not working. I've attached an example qvw. If anyone has the time to take a look, it would be very much appreciated.

       

      Best,

       

      Matt