I have a dataset where couple of machines are mapped to regions e.g. Emea , APJ , Americas. I have used an external excel file where i have included all the countries which are part of those 3 regions. There are 2 columns in my ext. excel file. Country and Region. Region column i have mapped with my dataset region. By doing this i am able to use geo map representing all 3 regions. Now in my dataset i have some machines and their predicted failure time (future time). How can i highlight the specific region to which the machine belongs based on the timestamp of failure alert?
Please post the sample workbook.