3 Replies Latest reply on Mar 31, 2016 10:50 AM by Brian Coggon

% Change Calculation MoM for Multiple Measures?

Brian Denneny Mar 28, 2016 12:07 PM

Hi All,

I have a sheet with data for leads, marketing qualified leads, sales qualified opportunities, and bookings segmented by month.

I want to have a % change for previous month column so I can see the difference in each different measure MoM. Unfortunately it seems like all of the tooltips that explain how to create a YoY field use only one measure which they'd like to know YoY or MoM for.

See image below:

I'd like a calculation between each month for % change.

1. Re: % Change Calculation MoM for Multiple Measures?

Brian Coggon Mar 30, 2016 12:09 PM (in response to Brian Denneny)

Hi Brian,

This is a Table Calculation - you can select the Calculation Type as "Percent Difference From" and the you can choose from Previous, Next, First, or Last...

Hope this helps.

Brian
Like Show 0 Likes(0)

Actions
2. Re: % Change Calculation MoM for Multiple Measures?

Brian Denneny Mar 30, 2016 12:37 PM (in response to Brian Coggon)

Thanks Brian. Unfortunately as I'm trying to do this I am noticing that I seem to have to select only one of the measures instead of using all of the measures.

Also is it possible to get this into a new row? See what I want ideally below:

Is something like this possible?
Like Show 0 Likes(0)

Actions
3. Re: % Change Calculation MoM for Multiple Measures?

Brian Coggon Mar 31, 2016 10:50 AM (in response to Brian Denneny)
Brian,

I have played around with sample - I am sure we can get it to look exactly like the excel sheet. But, the great thing about Tableau is that we can do MORE. Here is a quick sample using Table Calcs to show the difference in MoM%. If you had a larger set of data (as you grow or need to dig deeper) you will be able to see the difference in MoM, QoQ, YoY... however you want to present this information.

Hope this helps!
Brian

Example 203685 bc.twbx 16.9 KB
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

% Change Calculation MoM for Multiple Measures?

1. Re: % Change Calculation MoM for Multiple Measures?

2. Re: % Change Calculation MoM for Multiple Measures?

3. Re: % Change Calculation MoM for Multiple Measures?

Actions

More Like This