Create hierarchy chart

[#1]

Hello,

I have hierarchy variable:

Europe

Africa

Asia

Europe#England

Europe#England#London

Europe#England#Manchester

Europe#England#Liverpool

Africa#Egypt

Africa#Egypt#Cairo

Asia#China

I want to create a pie chart that contains the first child (for ex. England - 4, Egypt - 2 and China - 1)

something like this:

How can i do that?

Thank you!

[robert_mika · Accepted solution]

Use Calculated Dimension

Then Expression

=COUNT(TextBetween(data&'#','#','#'))

Script :

load * inline

[

data

Europe

Africa

Asia

Europe#England

Europe#England#London

Europe#England#Manchester

Europe#England#Liverpool

Africa#Egypt

Africa#Egypt#Cairo

Asia#China

]

[#3]

Thanks a lot! It was very helpful.

[robert_mika]

You are welcome.

Thanks for feedback