-
1. Re: Calculated Field to find visitor Drop-offs
Prasanna R Jan 30, 2019 9:33 PM (in response to monica singh)Hi Monica,
I have used Tableau Calculation to get the result. I have attached the 2018.3 version workbook for reference.
So you create lookup functions to see what is available in the next rows and compare them if they are in sequence as you want.
Note that initially you need to drag these 4 Stages into the row shelf as discrete and edit Table Calculation as shown below
Do the same for all the Stages so that we can fix how the table calculations work for these fields when used in any other calculated field.
Your final step will to check if they are in sequence
Best Regards
RP
*If this helps, then please mark it Helpful and Correct to close this thread
-
Sequence.twbx 36.9 KB
-
-
2. Re: Calculated Field to find visitor Drop-offs
Zhouyi ZhangJan 30, 2019 9:53 PM (in response to monica singh)
Hi, Monica
Not sure how you define the sequence of event name
One of the possible solution is to use parameters to define the sequence as shown attached workbook.
Below is the result, and you can drag the calculation keep or not to filter and select True only.
Please let me know if any question.
ZZ
-
Book1_v10.2.twbx 28.0 KB
-
-
3. Re: Calculated Field to find visitor Drop-offs
monica singh Feb 4, 2019 9:51 AM (in response to Zhouyi Zhang)I like both the approaches using Lookup or LOD to get to the results. Will work on it and ask more questions as my actual data is far more complicated.
Thank you Prasanna and Zhouyi