The chart visualisation has a drill down option but this is not very user friendly since drilling down into one of the rows still keeps the others on the screen and give a very cluttered look.
Example, I have a bar chart for electricity consumption in 2008, 2009, 2010, 2011, 2012. When I drill down in 2008, it would be helpful to see only Jan, Feb, March .. Dec of 2008 and not 2009, 2010, 2011 ..
Is there a way I can enable drill down to restrict rows only the the expanded field and not others.
Yes, it is possible.
Please configure the "chartOneLevel" parameter in the XML config:
<params>
...
<param name="chartOneLevel">false</param>
..
</params>