Hello sunil bhagavath,
A few questions to assist you further because we are a community that really loves to help users out.
1 - what version of Tableau are you using? It helps to always share this in your question or else you are likely to get response made with a version of Tableau that will not be able to be opened by your version. Tableau has increased the cadence of versions and knowing your version helps us help you.
2. The data supplied in the Excel file has a date field, a State, and a status. There is no count or identifier. Is each row supposed to be unique case and ticket? If so, an identifier would be helpful.
3. I am not sure what is desired for the outcome. A small mock up on a map in the question to show us would be helpful. Is the expectation to see 6 States colored in the view with 3 one color and 3 another (representing high/low)?
4. Please share the work you have tried so far in Tableau in a packaged workbook. A sample workbook goes a long way to helping the community understand what you have tried and would like to achieve.
Thanks and best of luck.