2 of 2 people found this helpful
Hi Jilani, you can do this with a table calculation. For instance:
DATEDIFF('day', ATTR([End]), LOOKUP(ATTR([Accept]), 1))
Make sure this computes along Table (Down).
can u send me without using the table calculations.
You can't do this in Tableau without table calculations.
ok because of regions are not in same order aswell as dates also
and that to i want to calculate only multiple regions having same id
if it is unique i dont want to calculate.
You can set the table calculation to restart on every ID or you can modify the calculation, e.g:
IIF(ATTR([ID]) = LOOKUP(ATTR([ID]), 1), DATEDIFF('day', ATTR([End]), LOOKUP(ATTR([Accept]), 1)), NULL)