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

    Complex Calculation on Date

    Wui Heng Goh

      Hi,

       

      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.