Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate Unique Visits

Data table linked to a Key and Date Dimension: I want to calculate a 1 the first time a Patient ID appears per service date. If a Patient ID appears multiple times on a particular service date,...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I ended up concatenating Pat_ID and Orig_Service_Date and then doing a Distinct Count of that

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I ended up concatenating Pat_ID and Orig_Service_Date and then doing a Distinct Count of that