Comments
-
I believe there is not really a way to do what I want to do using this type of graph. Agree?
-
I have tried two of the examples online (c-p/p), but not joy: (SUM(CASE WHEN YEAR(`CloseDate`) = YEAR('NOW') THEN `OpportunityAmount__c` ELSE 0 END)-SUM(CASE WHEN YEAR(`CloseDate`)= YEAR(DATE_SUB('NOW', INTERVAL 1 YEAR))AND month(`CloseDate`) <= month('NOW') THEN `OpportunityAmount__c` ELSE 0 END)) / SUM(CASE WHEN…
