Hi Tableau Community,
I'm trying to make 'Calculation1' to go from 1 to 4 based on the 'Second of Datetime' column and restart from 1 again if the Datetime column changes value, instead of all 4. See below:
Is this possible to achieve?
Try using Index function (No LOD).
Yes Layla it's possible. index() will do.
This post https://www.theinformationlab.co.uk/2014/09/29/understanding-tableau-table-calculations-using-index-size-part-1/
will give you a solid idea on how to use this function.
hopt this helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...