3 Replies Latest reply on Jul 4, 2016 9:32 AM by Yuriy Fal

Creating Top N Percent Difference Across Months

Yuri Kuzmycz Jun 17, 2016 5:24 AM

Hello All:

Hopefully this is pretty easy to pull off. I have a set of actual and plan monthly cost data per service per month. I've used the quick calculation functionality to determine the % difference month over month as compared to the prior month. I'm unable to, though, capture the top N % for the latest month. Ideally I'd like to only see June's top 10 largest % difference service costs.

I've created a parameter TopN and tried to create a set from the service. The % difference measure does not show up as an option within the set configuration. What am I missing?

Many thanks in advance!

1. Re: Creating Top N Percent Difference Across Months

Yuriy Fal Jul 1, 2016 11:53 AM (in response to Yuri Kuzmycz)
Hi Yuri Kuzmycz,

Since % difference is a Table Calculation,
you may want to use another Table Calc for sorting -- namely,
the one using RANK() function -- and a Table Calc filter on top of that.

Please find the attached as an example.
Hope it could help.

Yours,
Yuri

BTW I am Yuri Ivanych :-)

Top N by Percent Diff_YF.twbx 1.2 MB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Creating Top N Percent Difference Across Months

Yuri Kuzmycz Jul 4, 2016 8:09 AM (in response to Yuriy Fal)
HUGE thanks for the help! Works exactly as I wanted. Two quick questions:

Is there a way to hide the rank?
How did you change your parameter control to a slider? Mine only allows a value typed.
Like Show 0 Likes(0)

Actions
3. Re: Creating Top N Percent Difference Across Months

Yuriy Fal Jul 4, 2016 9:32 AM (in response to Yuri Kuzmycz)

Hi Yuri
Glad it worked for you.

1. Right click on Rank pill on Rows --> clear Show Header flag

2. Parameter [Top Customers] --> Edit --> Allowable values --> Range
This triggered a slider by default. Also Slider is an option for List (but not for All).

Yours,
Yuri
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Creating Top N Percent Difference Across Months

1. Re: Creating Top N Percent Difference Across Months

2. Re: Creating Top N Percent Difference Across Months

3. Re: Creating Top N Percent Difference Across Months

Actions

More Like This