1 Reply Latest reply on Jun 22, 2017 9:49 AM by Shinichiro Murakami

    COUNTD Where Dimension=True?

    Tabitha Polk

      Hello!

       

      I’m hoping you can help me out.  We are trying to do the following:

       

      Calculate the average # days from created date to close date by region and offering type for all LOST/WON IDs and then count the number of OPEN IDs where the sales cycle length (created to today) is greater than the LOST/WON average by region and offering type.

       

      Right now, we are able to get a count based on Lost/Won IDs, but we need the Open – this seems to be where our issues are occurring – comparing Avg Sales Cycle on Closed IDs to the current Sales Cycle Length of Open. I feel like we need a calc that will do something like: COUNTD([ID]) where Open Length > Closed Avg = True, but I keep hitting a wall when trying to create anything like this.

       

      Any ideas would be greatly appreciated. Thanks.