2 Replies Latest reply on Feb 16, 2016 5:35 AM by Rody Zakovich

    Window calculations

    Christine Nguyen

      I'm trying to sum up the users (right) and divide by the total number of places (left) in a window calculation to be able to use on a separate sheet. I don't want the detailed records. if I use just sum(users)/countd(places), the user is only counted one time, but I want it to be counted one time PER each place.

       

      To provide more context, in SQL, it would look something like:

      select place, count(distinct users) as count_users from table

      group by place

       

      Then I would do sum(count_users)/countd(place) in Tableau. i'm trying to avoid using a separate query so I can keep everything in one view.

       

      Example:

       

      Capture.PNG

       

      Thanks!