1 Reply Latest reply on May 3, 2019 10:40 AM by Daniel Stanish

    Percent calculation with date feilds

    Robert Granda

      Hello Tableau community,


      I am 5 days new into this product.  I do reporting using Excel and  find tableau very interesting.  At its simplest level, I like to replicate one of my reports in tableau and have not been able to do so. Hope this forum will be tolerant as I go through the training on this site.


      Simply put in my excel document I have four date column fields.  As someone enters a date, the fiftieth column documents the percentage accordingly.  Hence when all 4 fields have a date the last column marks it as 100%  useing the following excel formula =IFERROR(1/(1/COUNTIF(E4:H4,"<>")*4),"")


      So I understand that there should be a created calculated field to make this happen but not able to wrap my head on the syntax that needs to be used.


      Hope to hear from someone.