I am using a calculated dimension in a Pie chart as follows:
=IF(Message_Type = 'Error', 'Error' , 'Success')
The above 'IF' statement is working fine. But now the requirement got changed.
Now I have to include following Message_Types: Error, Warnings, Completed in the Pie Chart. But if Message_Type is not equal to Error, warnings, Completed it should flag as Success.