7 Replies Latest reply: Nov 3, 2014 8:58 AM by Marco Wedel RSS

    Distribution Graph

      Hi All,

       

      I have sales data that I would like to prepare a distribution graph from. So I can prepare a distribution graph for sales within certain constant bands by creating a calculated dimension.

       

      However, is it possible to have say sales in the following bands 0-500, 5001-1000, 1001-1500 and then the last group being sales above 1500. My problem is how to create this last group i.e. no. of clients above a certain sales value as the last bar.

       

      So far I can only create a distribution graph based on constant bands. How do I have a certain number of bands and the last band being all sales above the last band?

       

      Hope this makes sense.

       

      Thanks

       

      H