5 Replies Latest reply on Nov 7, 2018 6:13 AM by venkatram

    To check data status

    Faiz MH

      Hello All,


      I am new in tableau and in fact quite use to Excel before. I have a question on how can I check data availability using calculated field based on table below:


      In the table, there are 4 sales person and from sales locations, it's showing whether there is data for  both the 1st half and 2nd half of the year. For Sales Location A, Jim did not cover the area and for John, data is not available in Sales Location C. The rest of the locations has data as shown

      I tried to create simple if condition and able to get the green part but not the red and purple square. I think this portion is complicated to me.


      Hope some expert here can help with this simple table.


      Thank you.