Conditional Formatting for Dot Chart items?

Hi, I have this salary dataset which I want to display in a dot chart according to the Grades and Performance Rating.

I transposed this module to add the Grade and Performance Rating dimensions so I can display on the chart.

I have a line item "CF Rating" to be used for the conditional formatting. "Salary Display" line item is just so that the zeros don't appear on the chart.

What I managed to get for the dot chart now looks like this:

Each dot represents each Employee salary. The Employee also repeats in every grade dimension but it is not a problem as I can just hide the legend. Expected user behaviour would be that they can hover over each dot to see the Employee Name, Salary Amount and Performance Rating.

However, I want to colour each dot according to the Performance Rating of the Employee as set up in the module. i.e. Red for Low, Yellow for Performing, Green for Outstanding. Is this possible? I know it is possible in Tableau but would like to find out if there is a way to do it in Anaplan.

Happy to know if there is a better way of doing this and thanks in advance!

Thanks,

Peggy

Accepted answers

All comments

Misbah

@peggytham

I don't think you would be able to add those attributes on to the chart. Atleast I have not seen such functionality within Anaplan. It surely is available in Tableau.

Misbah

Miz Logix

peggytham

Thanks Misbah for the quick response! That's a pity that we can't do it in Anaplan yet... Perhaps an idea for future roadmap 🙂

Amaya

Hi @peggytham ,

How about using a Scatter plot, instead?

Convert 'Grade list item' and 'Performance Rating' to number format and plot them like below.

The scatter plot allows conditional formatting!

https://help.anaplan.com/5f30056b-80b8-42c6-839d-a8fc0521f290-Scatter-plot-and-Bubble-chart

Thus, you could draw a graph below.

I hope this helps,

Taichi

peggytham

Thanks Taichi for this idea! I thought about it too but it might be confusing for users as they won't be able to understand what is the Grade number straightaway. But worth a shot to test it out. Thank you for the suggestion!

ipekkirali

Hi - did you post this to idea exchange? I am on a similar boat and would love the conditional formatting for dot charts or some advanced feature to be able to get this type of chart in Anaplan.

peggytham

Hi I did not! Taichi's suggestion worked for my users so I went ahead with it. You can post it on idea exchange and I'll kudo it for sure!

Quick Links

Can you help?

Unanswered questions

Is there a workaround for Select function
Hi Anaplanners, I have a build where I want to capture for a missing mapping for those 2 input line item. This module is dimensioned by a chart of account list and it is not a hierarchy list but a flat list set up as a hierarchy. I would like to capture if there is any missing mapping for all the list item that rolls up to…
how to pull Date from the required Date
Hello team. It is very difficult to explain in words what I want to do, but I will try. everything should be clear in the screenshot. I have a LI: days shift - the number of days for which the data will be shifted. I have a date - just START() and date days shift after - the date on which the data will be shifted. In the…
Adjustments by Chart of Accounts
Hi community, I have a unique requirement for which I need an advise. My company want to adjust numbers per each CoA and this apparently is a key and mandatory requirement in future anaplan. Currently account is base level of hierarchy and imports and inputs happen at this level. I am now confused how I can give an ability…