7 Replies Latest reply on Mar 13, 2017 1:52 PM by Mithil Mangalore

    Applying Distinct Count of Days # to All Data

    Karina Melkonyan

      Hello! I am attempting to create a highlight table of average resource utilization by time of day and resource through tableau. Here is what i have so far:

       

      This is based on a full year of data. I took the total # of days that each resource was in use by time of day and divided it by total days of operations.

      As you can see above, there are some gaps in my data. This is because if a patient did not arrive to that resource within the 30 min interval in the data, my COUNTD formula does not compute for that resource & time frame combination.

       

       

      I used the following formula: { FIXED:COUNTD(DATE([EventTime]))}

      Is there another way to count distinct days and have it appear for all resources and time frames?

       

      Thanks for your help!

      Karina