1 Reply Latest reply on Aug 23, 2016 6:44 AM by khalid norat

    Count Distinct Issue - summing distinct deal numbers with value > $x.

    Ray Mullins

      Hi all,

      I would love to be able to count up the number of deals that have a value greater than or equal to $1,000,000. In the example data attached, the number of deals fitting this criteria is 5.

      This metric will be used as part of a bigger dashboard with date parameters etc. I have gotten 95% of the way there but getting the COUNTDistinct to display as a single figure with everything else hidden from display is proving difficult. I'm sure I have over-complicated it to date, all help is very welcome.

       

      Best regards,

      Ray.