How to create Inter related or Inter linked Charts
Dear all,
Please suggest me on this sceniro. I want to create Inter related charts.
I have create a Pie chart with 4 expressions
1. 0 - 3 Months Expression sum(if(trnType='Sales' and days<=90,invTotal))
2. 3 - 6 Months Expression sum(if(trnType='Sales' and days>90 and days<=180,invTotal))
3. 6 - 8 Months Expression sum(if(trnType='Sales' and days>180 and days<=240,invTotal))
4. 8+ Months Expression sum(if(trnType='Sales' and days>240,invTotal))
It working fine.
1. Now I want to create a one more pie chart
2. and one Straight table Chart
related to This First Chart,
suppose when I will click on any IInd slice ( 3 - 6 Months) of first Pie chart then my subsequent IInd Pie chart should show the total Product's sold value for that 3 - 6 Months. slice of First Chart.
In Straight table chart I want to show the Invoice details of select / clicked slice ( 3- 6 Months ) like No, Date, Due On, Customer name etc.
I notice several time that when we click on pie chart's slice pie data change in other charts on sheet.
In a pie chart, I think there is not much of a visual difference in using a dimension or separate expressions.
In a straight table you can hide the dimension, but then you don't see the dimension values (formerly known as your expression labels, right?) but you can use a pivot table and pivot your dimension to the top, that could look similar to what you currently have (well, I don't know what you currently have, so I am more or less guessing).
I believe the selection in a chart is done on a dimension value, in this example, you are not using a dimension, only four expressions, right? So there will be no selection. In your other pie charts, do you use dimension(s)?
You can create a table containing your four time periods and use this as dimension, then you should be able to select in the charts also. You either need to link this new field to you existing data or check for the dimension value and select the appropriate values in your expressions.
Yes, your are right I am not using any dimension, actually I have no need of single dimension suggest me If will take a dimension in this Pie Chart then can hide this dimension because dimension is no worth for me in this case
In a pie chart, I think there is not much of a visual difference in using a dimension or separate expressions.
In a straight table you can hide the dimension, but then you don't see the dimension values (formerly known as your expression labels, right?) but you can use a pivot table and pivot your dimension to the top, that could look similar to what you currently have (well, I don't know what you currently have, so I am more or less guessing).
