Thank you Manideep for your response.
I looked into this. Actually my requirement is to compare the notifications in DATE (every day - date) level and then highlight as following : -
Could you please advice more to achieve this in calendar chart - (I tried with attached workbook - could not find out a way to represent in day level), please advice -
1. If Notification environment (measure) is null for environment 2 and environment 3, highlight as RED
2. If environment 1 not matched with environment 2 then highlight environment 2 as RED.
3. If environment 1 not matched with environment 3 then highlight environment 3 as RED.
Dear Shikha - If you have observed this, then the analysis has been done at Day level only. Let's take a day June 17 2016. Notification 1 and Notification 3 is abnormally high so "Red", but Notification 2 is low so "Green"