2 Replies Latest reply: Feb 4, 2013 10:31 AM by jjmaxwell RSS

    Stacked Bar Chart Based on Field Count

      I'm trying to make a somewhat complex Stacked Bar Chart. Each stack in the chart should be based on how many times a certain field occurs within that time period. I have the period as my dimension. I have built similar charts by hardcoding expressions for each "Stack" in the chart.

       

      Ie. I could have three stack's by making three expressions:

           Stack 1: (sum(if(Area = 'Chicago', 1, 0))

           Stack 2: (sum(if(Area = 'New York', 1, 0))

           Stack 3: (sum(if(Area = 'Atlanta', 1, 0))

       

      In this example I am using Area as my field. The problem I have is that I have about 500 possible 'Area's'. Do I have to make 500 expressions for each possible option? I really just want the top 20 occuring Area's displayed on the chart. Is there a way to count / display just the top occuring area's? How do I do this?

       

      Thanks a lot for your help