5 Replies Latest reply on Feb 2, 2018 3:35 AM by Zhouyi Zhang

    Complex Calculation on Date

    Wui Heng Goh



      I need some assistants on calculating the number of days perform the Uric Acid test.


      Column A represents different patients.

      Column D represents when the patients visit the hospital Outpatient clinic. The first visit to the clinic is considered as the index case.

      Column F represent the days when Uric Acid Test is performed. The days are calculated based on the difference between the performed date and index case date


      I need to use Tableau auto calculate Column G and plott the monthly trend on Uric Acid (UA) Test performed at least once per 6 months.


      Can someone advise me how to do these in Tableau?


      Thank you.