Show value of the same month in previous year

Julia Mazur shared this question 4 months ago
Answered

Hi all,


I would like to know how to display the value from the previous year from the same month (e.g., Jul 2018 compared to Jul 2018). More specifically, I would like to display the delta to the value from the same month in the previous year. I know about the advanced function "delta from last", but this does not solve my problem as I have month level data.


Is there a function to calculate this? How can I solve the problem?


Thanks!

Julia

Comments (4)

photo
1

Hi Julia,

Firstly, caveat, I don't work for Yellowfin, I work for a Yellowfin Partner.

Is this the sort of thing you were looking for?

/846da798fb2ad5f8206fa094db305283


Lex

photo
1

Hi Julia,


Lex is absolutely right! Using an Append Subquery you can use a Date filter to filter out the year, and then perform a Difference of Columns Advanced Function to take the difference between the months. It may look similar to the below:


/7dff7e55daca0a1f5338363d9188cacc


Kind regards,

Simon

photo
1

Hi all,

yes this is exactly what I need.

Thank you very much.

Regards,

Julia

photo
1

Hi Julia,


Not a problem. I will go ahead and mark this as answered, feel free to re-open it at a later date if you have any further questions.


Kind regards,

Simon