4 Replies Latest reply on Apr 24, 2018 1:32 PM by waqar ahmad

    Distinct Count using window_sum() Returning a range?

    waqar ahmad

      Hi Everyone,

       

      I was not able to find this issue this time when searching but have come across it online before.

      Could someone explain to me the dynamic behind how this is working and how I can get my particular count only instead of seeing a X to Y format.. Y being the proper count number I'm after. I'm using a Window_Sum on a distinct field count..

       

      Example:

       

      Total count = 50

      Count showing up as 21 to 50.

       

      please see screenshot for what I'm seeing exactly. I would like to see just 50 .. not 21 to 50. I tried doing a distinct(count(Field)) but that just showed me the number 1. Not sure why but this is the closest I've gotten to what I'm after..

       

      Thank you,

      W