Stacked Bar Chart Based on Field Count

[#1]

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

[alexandros17 · Accepted solution]

Use Area as dimension and then use dimension limits (is the second sheet in the properties of the object) to limnit first 20 values ...

Hope it helps

[#3]

That works. Thanks.