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!