Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a mekko chart, which has a dimension called Hiherarchy2. Hierarchy2 is a subgroup of Hierarchy1.
How can I have the same colour for all Hierarchy2 belonging to the same Hierarchy1?
Attached is a dummy app.
Thank you in advance for your help!
Regards
Yes, use for example something like =color(FieldIndex('Hierarchy1' ,Hierarchy1)) as background color expression. If you have a lot of values in Hierarchy1 (you do) you may want to consider creating a table in the script to assign colors to the Hierarchy1 values. See this blog post for more information: Colors in charts
Yes, use for example something like =color(FieldIndex('Hierarchy1' ,Hierarchy1)) as background color expression. If you have a lot of values in Hierarchy1 (you do) you may want to consider creating a table in the script to assign colors to the Hierarchy1 values. See this blog post for more information: Colors in charts
Thank you for the suggestion. Indeed color(fieldindiex ... works magically! But i'll need to create a separate table as there are so many value.
Thank you!