Delta Difference

LJ · 2023-05-01T19:38:45+00:00

There was an error rendering this rich post.

Hi Everyone,

Hope you can help me with this one. I am trying to get the delta difference from both 2 months. Just to show how many volume increased previous to current month. Any reccomendations?

Thanks!

Find more posts tagged with

Accepted answers

GrantSmith

Is your data being pivoted? What does your raw data look like? How many records do you have per month? What are you grouping your data based on?

You'll likely need to utilize a LAG window function to get the prior month's value to calculate the difference in a beast mode.

All comments

GrantSmith

Is your data being pivoted? What does your raw data look like? How many records do you have per month? What are you grouping your data based on?

You'll likely need to utilize a LAG window function to get the prior month's value to calculate the difference in a beast mode.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of