5 Replies Latest reply: Apr 29, 2014 10:26 PM by Sundarakumar Kalaimani RSS

    cluster bars by arbitrary number (for readability)

      Hello. I have a bar chart with ~700 bars (please see attached). I would like to group them into groups (say of 10, or 25, or 50) to increase readability. I may cluster them in groups of n/10 to show deciles. Again, this is purely for ease of viewing.

       

      From what I've read, clustering needs multiple dimensions. I tried adding a calculated dimension of =FLOOR(ROWNO(TOTAL),25) in order to get them into groups of 25. This formula doesn't calculate when it's a dimension. It works perfectly when I use it as an expression, but then I cannot use it for defining bar clusters.

       

      Any suggestions?

       

      For what it's worth, I'm much more comfortable on the scripting side of things rather than the layout/visualization side of things, so I apologize if this is an easy one that I'm missing!'

       

      Thanks.