3 Replies Latest reply on Feb 29, 2016 7:12 PM by Adam Crahen

    Flag Mandatory Fields

    Jagjit Singh

      Hi All,

       

      I have a list of 32 action items and there are certain fields which are mandatory i.e which need to be filled in with a date and cannot be ignored. Users either need to ignore the action item if not applicable or put in a date when the task was completed.

       

      I want to write a calculation in Tableau that will flag:

       

      1) If the mandatory field has the ignore value. In certain cases users accidentally mark a mandatory field as ignore.

       

      2) Mandatory field is NULL.i.e there is no value in the actual date column against the mandatory field.

       

      Please find attached the sample data and the mandatory field in the second worksheet.

       

       

      Thanks

      Jag