Rank and Window? Lag?

damen

So I have a dataset that captures quarterly expense data.

I have been tasked with adding an 'expense ratio change column'

Basically, I need to know the % change of expenses changed from quarter to quarter by project

I know the math on this ((p2 - p1) / (p1)) but am not sure how to tile it in domo to make sure it is taking into account the 'project_number' (not shown)

Any suggestions? I need to create a column in the dataset btw, this is important

MichelleH

@damen

The Lag function should be used to add a column to hold the prior quarter expenses. In your first screenshot, name your new column "Previous Quarter Expenses" (or something similar), change the function drop-down to "Lag", run the function on your current quarter expense column, with an offset of 1.

Once you've created this column, then I would add your variance calculation as a beast mode in your card like this:

(sum(`Current Quarter Expenses`) - sum(`Previous Quarter Expenses`))/sum(`Previous Quarter Expenses`)