This is definitely a trickier question! I used PREVIOUS_VALUE() to create datetime groups where each time was less than 3 seconds after the first time. And then in a second calculation, any time the datetime group changed, I returned a one.
Hope this answers your question!
example is valid.twbx 53.2 KB
I was going to add that I don't think this is possible in Tableau in the view without a table calculation function based on these requirements.
I totally did not see that you didn't want a table calculation! I agree with Patrick though. Because we want to read along values that need to be ordered and do not have a predictable interval, it will be necessary to use a table calculation.
The Tableau website has an Ideas section where customers can add, comment, and vote on features they would like to see in the product. Votes are used to help prioritize new features. Our Development team also loves to see everyone's use cases in the comments, which helps them better design features that will meet the most possible needs.
I recommend voting on https://community.tableau.com/ideas/6968