Is there a way to show % change between periods?

Hello @MattGo, 

We can utilize beastmodes to find this. 

To find the current quarter we would use the following formula: 

SUM(CASE
WHEN QUARTER(`Date` ) = QUARTER(curdate()) 
AND    YEAR(`Date`) = YEAR(curdate())
THEN `Value`
End)

To find the previous quarter we would use: 

SUM(CASE
WHEN QUARTER(`Date` ) = QUARTER(SUBDATE(curdate(), INTERVAL 1 QUARTER)) 
AND    YEAR(`Date`) = YEAR(SUBDATE(curdate(), INTERVAL 1 QUARTER))
THEN `Value`
End)

To find the % change we would use the basic formula: 

(Current - Previous) / Previous

Using our formulas we created above, we can plug them in, in place of the words: 

(
SUM(CASE
WHEN QUARTER(`Date` ) = QUARTER(curdate()) 
AND    YEAR(`Date`) = YEAR(curdate())
THEN `Value`
End)
-
SUM(CASE
WHEN QUARTER(`Date` ) = QUARTER(SUBDATE(curdate(), INTERVAL 1 QUARTER)) 
AND    YEAR(`Date`) = YEAR(SUBDATE(curdate(), INTERVAL 1 QUARTER))
THEN `Value`
End)
)
/ 
SUM(CASE
WHEN QUARTER(`Date` ) = QUARTER(SUBDATE(curdate(), INTERVAL 1 QUARTER)) 
AND    YEAR(`Date`) = YEAR(SUBDATE(curdate(), INTERVAL 1 QUARTER))
THEN `Value`
End)

Please keep in mind that the columns in blue need to be replaced with your column names. 

If you have difficulty adding this to your card you can reach out to DOMO's support team. 
Email: support@domo.com
Phone: 801-805-9505

Hi @ilikenno,

How would you do the same for a year over year change. Would I just remove the "quarter" part of this formula?