I have to nest region and years in category of column chart.
I have to have first regions nested ,then Years .
I drag both region and year data item in to categories of a column chart.
SO they dont appear one below other, instead first region and then years in the same line.
Is it possible to nest them like shown below in x axis.
East West East West
FY2014 FY2015
Thanks,
Nithya
Hi All,
If I add nested rows in category , still it doesnt nest rather comes as additional values in x axis.
But there is one sample report showing the values nested in categories for chart.
Please let me know if there is a way to set the nesting working.
Thanks,
Nithya
Quote from: nithya1224 on 28 Aug 2014 04:36:01 PM
Hi All,
If I add nested rows in category , still it doesnt nest rather comes as additional values in x axis.
But there is one sample report showing the values nested in categories for chart.
Please let me know if there is a way to set the nesting working.
Thanks,
Nithya
Unless I'm misunderstanding, the example you're posting here is simply Year as the Categories and Region as the Series?
MF.
No both years and regions is nested in categories that is x axis .
Quote from: nithya1224 on 29 Aug 2014 07:30:06 AM
No both years and regions is nested in categories that is x axis .
Hi,
In that case you're not making your requirement clear. What does "nested" mean? What are you expecting to see? The text you added earlier looks like you want groupings of columns (for years) on the x axis and columns for each region clustered within each year? If so, adding Year to the Categories and Region to the series will provide exactly this.
Here are two examples of charts using the same data. The first has Region in Series. The second has Region nested within Year in Categories. Are either of these what you require?
(https://image.ibb.co/mvvTtQ/Nested_Categories_zps25faa16a.png)
MF.
Yes the second one , I had mentioned like
East West East West
FY2014 FY2015
in x axis
. How were you able to nest the region with in year in categories as shown in your second chart..
Just dragging both data items in to categories doesnt give me the output.
Thanks,
Nithya
Quote from: nithya1224 on 29 Aug 2014 08:06:04 AM
Yes the second one , I had mentioned like
East West East West
FY2014 FY2015
in x axis
. How were you able to nest the region with in year in categories as shown in your second chart..
Just dragging both data items in to categories doesnt give me the output.
Thanks,
Nithya
First drop the Year item into Categories.
Then drag Region and drop it just below Year in the Categories area - look for the drop zone you see below:
(https://image.ibb.co/jcHf7k/Drop1_zps99186841.png)
Once you let go, Region appears below and indented from Year in the Categories area:
(https://image.ibb.co/bGEhL5/Drop2_zpsc6be014b.png)
Cheers!
MF.
Thanks a lot MFGF, I tried this and it worked in normal charts. But the next question is I tried the same in rave visualization chart but was not able to drop one item below other. Is it a limitation in rave visualization chart.
Thanks,
Nithya
Quote from: nithya1224 on 29 Aug 2014 08:28:43 AM
Thanks a lot MFGF, I tried this and it worked in normal charts. But the next question is I tried the same in rave visualization chart but was not able to drop one item below other. Is it a limitation in rave visualization chart.
Thanks,
Nithya
Visualizations are completely different - they support only the structures they are designed to handle. This means you can't nest items in a visualization as you do with a chart. To get the same effect in a visualization would require the vizJSON code of the visualization to be modified to allow this (ie you would need to re-write the visualization).
Cheers!
MF.