CODEWITHSUNDEEP
tableau-apilevel-of-detail
Rajesh Kota
Rajesh Kota

Reputation: 35

Handling repeated records in Tableau fixed calculation

I am trying to write a fixed calculation in tableau to get the minimum start date of employee when there is a change in Subteam. Attached a screenshot to give you an idea of what I am trying to do. It has my current result and expected result as well. Any help would be appreciated.

Thank youTableau Data

Upvotes: 1

Views: 93

Answers (1)

Fabio Fantoni
Fabio Fantoni

Reputation: 3167

Starting with this sample input (I added a second employee):

Date        Emp ID  Team
29/02/2020  1234    AI
31/03/2020  1234    AI
30/04/2020  1234    ML
31/05/2020  1234    AI
30/06/2020  1234    AI
01/01/2020  567     AI
01/04/2020  567     ML
01/07/2020  567     AI
01/08/2020  567     AI

You can approach the problem using "previous" records, using LookUp function, based on EmpId and Team:

LOOKUP(MAX(str([Emp ID])+[Team]),-1)

Now you need to filter just rows where this conditions is true:

min(STR([Emp ID])+[Team]) != ifnull([LookUp],'XXX')

The output could look like the following: enter image description here

Upvotes: 1

Related Questions