Remove >= symbol in target and change to number format
Compare in tableau
If you remove the logical condition then how would you compare?
Hi - attached is a workbook.
Took the Target and used a calc to split the >= off and just leave the number (converted to INT)
Then created a "Flag" calc which is 0 if the values did not exceed the target and then used a diverging palette to have 2 colours, red for 0 and white for 1
Hope this helps
Sales.twbx 16.2 KB
Thanks for your answer.
I just wanted to know how would you split the column if there is no space or any special character.
And this is not the exact answer to my question
If you see the 3rd row and 1st column it did not meet the target so it should be in red. (Queue Name = C | Month = Jan)
Yes Amar, I just wanted to know how we can compare the values against the target.
However in the image posted bu you does not meet the exact requirement.
If you are aware about regex_extract then It would be helpful.
I'm able to extract the number value but facing the challenges with decimal number.
Amar - I cannot see any attachment, please upload
please see attached image. if it is Correct or helpful for you.
Amar D. Savale