I think using reshaped data would be easier in the long run, since Actual/Forecast/Goal are elements of the Cycle dimension, we have to be looking across rows to get the values to do each calculation, and in Tableau that requires table calculations. My thought with the reshaping is that you'd have actual, forecast, and goal be separate columns within the data, then the comparisons would be much easier to create.
However, like most calculation tasks in Tableau, there are different ways to do this, I've attached one way. There are set of three calculations for each comparison: Actual to Goal, Actual to Goal %, and then Actual to Goal Color, and the same for Forecast. These make use of the LOOKUP() table calculation set to Compute Using->Cycle and are completely dependent on the existing ordering of Goal/Forecast/Actual in the view. Then the two Color calcs are used in a final Highlight Color calc that is then used in the view.
The "crosstab workout" view shows the calculations, I applied them in the "is this what you want?" view. Note the I had to change your custom shape for the duration to a circle because Tableau won't apply colors to custom shapes. I also used the color blind color palette because using red and green to show variation without another indicator (like position or shape) is not best practice since >7% of males have some degree of color blindness.
Let me know if this works for you!
Thanks a lot Jonathan...
Now I need only to understand how to utilize it for my further analysis
You're welcome! If you have any questions, let me know.
Thanks for your answer. Your tableau example is awesome.
Think to I want to have a deeper learning on the topic, do you have any recommendation such as blog or book or example?