select best chart

[#1]

I am not able to select best chart to show data wih 3 levels country, state, city. I can't use drill down approach, I need to show all the data in a single chart but even stacked bar graph or mecko chart is not working as dataset is huge. Can anyone help?

[Gysbert_Wassenaar]

Perhaps you can use a calculated dimension. Something like =Country & '-' & State & '-' & City.

If you need more help please post a sample document: Preparing examples for Upload - Reduction and Data Scrambling

[#3]

Thanks for the response.

As Country > State > City all need to be shown and compared at respective level. Is there a way I can show the data and compare them too in a single chart?    

[Anonymous]

Maybe pivot table works for you(?)

[MayilVahanan]

HI

Try with straight table or pivot table..

Hope tat helps

[#6]

Thanks all, Pivot table works fine.

[brijesh1991]

Since Pivot is providing Expand/Collapse functionality; It will be best choice!

[MK_QSL]

This is how I have showing values in my application.

[brijesh1991]

Is it Stacked Bar Chart or Mekko Chart you used?

When Data value will be long, then may be data values will be overlapped, so personal suggestion, just use fast change functionality(Your chart+Pivot Table) along with your created chart.

So if someone wants only data values, then they can have it. . .

[#10]

True Brijesh, I have used pivot with my chart and it is working fine.

Thanks for your inputs.