I have a large inventory with serial numbers for each item. I can find the year it was bought based on the serial numbers.
Example:
if the serial number is between 1-200 it was bought in 1950,
201 to 400 = 1951
401 to 600 = 1952
and so on all the way to 2023. Is there a way to create a quick calculated field that gives me the year purchased without making the largest if/then calculation in tableau history?
2 answers
Hi @Gabriela Alfaro
I love these sort of questions! ...like a Tableau Sudoku puzzle!
I think this one does the trick
1950
+
int(([Order No]-1)/200)
