CODEWITHSUNDEEP
formulatableau-apipartition
Steven Cunden
Steven Cunden

Reputation: 435

How to create partitioned deciles in tableau? (decile within certain groups)

So I need to create deciles for a variable, but not across the total column, i need partitioned deciles. Essentially, here's what my data looks like:

EmployeeID | Year | Position | Salary

I need to create deciles within Salary, but by year and position. So 10 groups for each position in a given year.

I am new to tableau and struggling to come up with the formulas to achieve this.

Any help is appreciated

Upvotes: 1

Views: 727

Answers (1)

user12029183
user12029183

Reputation:

Create deciles by using PERCENTILE function in Tableau. Example for 2nd Decile:

PERCENTILE([Measure Value],0.20)

Upvotes: 1

Related Questions