1 of 1 people found this helpful
you could always use the above tables to create a dummy workbook to share
Table calculations (rank() ) are at the bottom of the order of operation
so focus on using other table calculations like window_count, window_sum tec to complete your viz -
you will not be able to use LOD's on a table calculated field since they precede them on the order of operation
This is the approach with using tablea calc, but this is also complicated and not sure performance meet your expectation of not in case of huge data set...
*** I changed 5 to 6 to make it work******
Step 1 (sheet "1")
Step 2 (sheet "2")
step 3 (sheet "3")
filter only "true"
tableacalcsample_SM_10.5.twbx 17.3 KB
Hi Shinichiro Murakami, thank you so much for this.
You've gotten me very close but I'm still a little off.
I've attached a dummy file this time which mimics pretty closely what I'm trying to do in my actual workbook.
On the sheet "Close":
The numbers should be 5,4,1,3,3 respectively.
Do you have any ideas here?
Dummy File.twbx 19.8 KB
It's quite difficult to understand what you want to achieve with new logic.
Please clarify whole of your intent.
I men the sets, filters or top you made are all impacting the results.
Here's the general logic of what I want to do:
- Look for session_id's that viewed page X
- Of session_id's that viewed page X, what pages did they view most often
- Of those pages, what order do people most often view them in
In Tableau, this is coming out to:
- Create a field called "convert" which is true if page_id = the parameter EndPage
- Create a set of session_id's called "Converters" where the max for convert is true
- Take a distinct count of the "Converters" session_id's by page_id and take the top X pages, create a set called TopPages
- Use the field "position" to determine what order they viewed the "Top Pages" in (descending).
- Count the distinct session id's that viewed each page in that order
Hopefully that doesn't confuse you more than help you.
In the attached file, I've actually been able to accomplish what I basically want visually:
However, I can't get it to print out the totals for each bar chart. While the bar charts reflect the right number, I'm finding no way to get tableau to show it.
Let me know what you think and thanks for the help so far,
Dummy File.twbx 19.4 KB
Yes, sorry! You're correct. It should be 5,4,1,1,3.
Sorry, I am totally messed up myself and put this on hold.
No problem, thank you for the input so far!
Same old trick -- using a pair of 'magic' RANK-based calculations
to count the number of Marks in each Table Calc-based 'bin' (Size)
and to show only one Mark for each 'bin' on a view (Filter).
Please find the attached.
Dummy File_v10.5_YF.twbx 35.7 KB
Thank you, Yuri,
Yes, I remember you mentioned this before, but could not find that post.
Your following up is always very helpful.
I'm afraid i don't quite get it.
How the Marks with the [Page Id] = 'A' could be on a view
when the [Top Pages] Set filter has the values of C, D and F only?