Hierarchy Filter on a Charts

Hello all,

I have a plant hierarchy with Region > Location > Plants.

On a Ux Board I have published the sales achieved at Region, Location and Plant level. However, I would like the user to be able to select a Region on the chart and be able to see associated locations and plants only. Similarly if the user selects a location on the chart, only the associated child plants should show. Is this possible?

Activating hierarchy filter in the Plant wise grid results in the below outcome which is not what I want.

Accepted answers

All comments

Konstantin97

Hi @saket22!

Looks like you have only one plant in the North region, why is it not what you want?
Could you explain what you want to see when you select only north region?

For such problem possible solutions might be:

Activate hierarchy filter
Create a two selectors(applied to users) on top of the page, where users can select relevant region and location. And then set a filters on the grids based on user selection

Maybe the second option will fit your needs

Thanks,
Kostya

saket22

Hi @Konstantin97

The problem is that when I select South in the region grid, it does not sync with the Location grid nor does it sync with the Plant grid. However if I change the region grid to a pie chart, the hierarchy filter is working fine.

Screenshot for hierarchy filter working with pie chart. I have selected South in the pie chart below:

The location and plant grids above are showing only relevant list members which are children of South region.

Screenshot for the same functionality not working with bar chart. Below screenshot is also after selection of south region:

Here neither the location grid nor the plant grid got filtered with the children of south region list member.

Appears to be a bug?

Konstantin97

@saket22

Yes, I tested this by my own.

Looks like when you press the Region chart it selects series 1 instead of a region.

You can try to repivot region (and also location) graph. Try to move hierarchy dimension from rows to columns.
It will change the view a bit, but still it looks fine.

In this case synchronization works

Kind regards,
Kostya

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385