7 Replies Latest reply on Oct 17, 2016 6:47 AM by Yuriy Fal

    How to create dynamic ranges based on percentile values?

    Carol Au

      I have a bar chart viz where I want to color the bars by the number of orders.  I am limiting the color groups to 5 and want to create ranges that are dynamic (can be applied to another data set with more or less orders).  In the attached example I was able to do this using the RANK_PERCENTILE function.  I labeled the "Color Groups" 1-5.  However I would like for them to be dynamic and display the actual upper and lower ranges (ie 0-215; 216-307; 308-576; 577-777 ect) for the groups instead.  Do anyone know of a way to do this?