Drilling down into details from Charts
Let me illustrate with an example of the situation that I am hoping to solve. The DB in question is Super Store Sales. Let us say that I have a bar chart which shows me the data for the SUM(Sales),SUM(COST) [Y - Axis] against Date in terms of quarters [X - Axis] with User Filters for Product Category and Product. Image shown below:
Now if I click on any of the bars I will be displayed the underlying data for the selected parameters corresponding to the bar. But what I want is to be able to do is somehow provide the user with the ability to investigate further into the detail view of the data from this summary view. For example, if the user clicks on the Q1 - Total Sales bar, he should be displayed another chart which displays the Total Sales data for Q1 distributed in terms of maybe the Region and the Product Category i.e. to provide the user the ability to drill down into further details from a summary chart. Something like the chart below:
Can anybody suggest me a way to achieve this in Zoho, if the capability exists, or suggest some alternative way to achieve the same result?
Now if I click on any of the bars I will be displayed the underlying data for the selected parameters corresponding to the bar. But what I want is to be able to do is somehow provide the user with the ability to investigate further into the detail view of the data from this summary view. For example, if the user clicks on the Q1 - Total Sales bar, he should be displayed another chart which displays the Total Sales data for Q1 distributed in terms of maybe the Region and the Product Category i.e. to provide the user the ability to drill down into further details from a summary chart. Something like the chart below:
Can anybody suggest me a way to achieve this in Zoho, if the capability exists, or suggest some alternative way to achieve the same result?