9 Replies Latest reply on Jun 29, 2018 8:00 AM by Zhouyi Zhang

    Dividing sum by filtered distinct count

    Gino Ceriani

      Hi everybody,

       

      I am fairly new to Tableau and cannot figure out how divide the sum of my paid amount by the distinct count of the episode. For example, each episode has multiple fields. Every episode has a trigger, but not everyone has PTOT or Home Health I only want to divide by the distinct count of the trigger. Right now when i do Sum(Allowed Amount)/Countd(Episode id) it divides by however many there are in each category. I know this is probably hard to follow so I have added a packaged workbook.

       

      Thanks,

      Gino