Hi team,
There is one Numbered List(Site List) and a Line Item(WFC).
And we need a Chart(Dot Chart) with WFC >6 and WFC <6 in different colors.
Can you please help me on this.
Β
Thanks
@saurav4ssΒ
Conditional formatting in the UX uses a line item number reference to determine what colour to use.Β
Therefore, create a new line item in your target module and using IF THEN ELSE create a condition in which a +1 is returned when WFC > 6 and a -1 is returned when WFC < 1.
I would also caution as to what happens when WCA = 1.
Therefore, use a statements similar to the following;
= IF WCA > 6 THEN 1 ELSE IF WCA < 6 THEN -1 ELSE 0
Zero is return if neither conditions are met.
In the UX when setting up the dot chart use this line item to inform the conditional formatting.
Good luck,
Chris
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a listβ¦
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
