Hoping someone can help me figure out why my POP Beast Mode calculation returns 0% in my charts. I want to compare current quarter to last quarter. I may also modify the calculation to compare last quarter to 2 quarters ago. I am only using two fields from my dataset, similiar to this table and my dates are always the 1st day of each month.
Month | Attributed Pipeline |
1/1/2018 | $1,000 |
2/1/2018 | $1,500 |
3/1/2018 | $6,000 |
4/1/2018 | $9,000 |
This is my Beast Mode calculation that returns 0% in my charts. I tried SUM before my case statement, but that did not change the results.
(CASE WHEN ((year(`Month`)=year(curdate())) AND (quarter(`Month`)=quarter(CURDATE()))) THEN `Attributed Pipeline` END / CASE WHEN (quarter(curdate())=1) THEN (CASE WHEN ((year(`Month`)=(year(curdate()) - 1)) AND (quarter(`Month`)=4)) THEN `Attributed Pipeline` END ) ELSE (CASE WHEN ((year(`Month`)=year(curdate())) AND (quarter(`Month`)=(quarter(CURDATE()) -1))) THEN `Attributed Pipeline` END ) END) -1
Thanks in advance for any help!!