Hi @Chris_Wood,
Welcome to our community.
In this case, you can consider using our AQL Expressions. There are 2 functions that are helpful in your case (previous() or relative_period()).
To illustrate, let’s say you have the sample data
previous()
You can use previous() to get the value of the previous row in a offset relative to the current row.
Thus, your expression will be like below
previous(
sum(model_name.transaction_units),
order: model_name.transaction_date
)
After having the value of the previous row, you can calculate the % Change
(
(sum(model_name.transaction_units))
-
(previous(
sum(model_name.transaction_units),
order: model_name.transaction_date
))
) *1.0
/
(
previous(
sum(model_name.transaction_units),
order: model_name.transaction_date
)
)
For more information, you can refer to our doc here < previous | Holistics Docs (4.0)>
relative_period()
Or else, you can use relative_period()
For more information, you can refer to our doc here < relative_period | Holistics Docs (4.0)>
Please let me know if you have any questions.