Trying to use the forecast value in chart properties but getting the error

I'm trying to get a forecast of quantity of sales for the current month using the last value projection in the chart properties. When I select the Forecast Value option, I get this error: 

An issue has occurred during processing. We are unable to complete the request at this time. 
 
Why am I getting this and how do I get around this? It only occurs when I select the Forecast Value, any other option works fine.

 

Comments

  •  

    Are you using a beastmode as the forecast value?

  • Yes I am. Is that the reason why it's not working?

  • Mind sharing the beastmode?  Might help understand what is going on


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
  • Here it is:

    SUM(
    CASE WHEN `Win Date` IS NOT NULL THEN 1 END
    )

     

This discussion has been closed.