Nested Graph & Graph/Chart color based on value

Sachinsourav02

Dear Anaplanners,

I'm stuck on this particular case wherein

Is it possible to get nested graphs ? Any workarounds, i did see them posted in ideas exchange.
Secondly would like the graph to have a dynamic color scheme based on the values. Example: Refer below table, 4 teams, each could have dynamic members and each member has a rating. If i were to need a horizontal bar graph that displays the teams and its respective members and their ratings…with ratings all carrying colors based on the scheme below, 0-5 a shade of red, 5-7 a shade of yellow and above 7 green shade.

Any help, guidance or workaround on this would be highly appreciated.

Much Thanks

Accepted answers

All comments

HimanshuRaj

Hi @Sachinsourav02

Yes, you can make nested graphs. Also check chart features on Anapedia to get more idea of what you exactly need
While setting up conditional formatting, you can manually decide range and it's colour in UX. unfortunately, it cannot be linked directly to module line item. It needs to be updated manually in case any rating change is done

Cheers!!

Sachinsourav02

@HimanshuRaj

Thank you for your reply !

1) Would you be able to help me with the page that talks about nested graphs ? In my search i was unable to find them, in fact, is saw them in ideas exchange so i presumed it was not an available feature. For example, if you create a table like the snip i showed, the classic dashboard denies you from creating a graph/chart, it becomes greyed out.

2) I'm aware you can do it manually but rating almost changes daily, its frequency is too high for a manual approach hence checked if an automated way is possible

HimanshuRaj

@Sachinsourav02

If you could keep one dimension in row and another in column, you should be able to create a similar chart. If you have a visual screenshot that could help, then also please share

Cheers!!

Sachinsourav02

@HimanshuRaj

Thanks for your reply !

Unfortunately that would not help, I have three dimensions:
1) Team List

2) Player/Employee List
3) Line Items

I want to show the graph like this:
As you can see in the below snip: Team A, B & C are sub classified into the employees/players and then their respective scores

HimanshuRaj

Hi @Sachinsourav02

To get this chart in Anaplan, you need to create a concatenated list from these 2 lists and using that list in a different module, you can create this chart

Cheers!!

Sachinsourav02

@HimanshuRaj

Yes already explored that route, it was ruled out with the potential size constraints we would hit. Hence was looking for simpler nested graph options like how we do in excel.

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