Hi - i created several Beast Mode formulas (TQ, LQ, QoQ). I have no issues adding TQ and LQ to a Pivot Table chart. When I add QoQ beast mode to the Pivot Table, no values are populated.
The QoQ formula is a difference of TQ and LQ. I can add TQ to TQ, or LQ to LQ and get a result. I just don't get a result if I mix TQ and LQ.
Is it a Domo performance issue? Eventually I want to divide the difference with LQ. What do you think the issue is?
Thanks in advance!
Beast Mode formula:
--2_Quarters_ago
((CASE WHEN (QUARTER(CURDATE())=1) THEN (CASE WHEN ((year(`Quarter`)=(year(CURDATE()) - 1)) AND (QUARTER(`Quarter`)=3)) THEN `Value` END )
ELSE (CASE WHEN ((year(`Quarter`)=year(CURDATE())) AND (QUARTER(`Quarter`)=(QUARTER(CURDATE()) -1))) THEN `Value` END ) END) -
--LastQuarter
(CASE WHEN (QUARTER(CURDATE())=1) THEN (CASE WHEN ((year(`Quarter`)=(year(CURDATE()) - 1)) AND (QUARTER(`Quarter`)=4)) THEN `Value` END )
ELSE (CASE WHEN ((year(`Quarter`)=year(CURDATE())) AND (QUARTER(`Quarter`)=(QUARTER(CURDATE()) -1))) THEN `Value` END ) END) )