
1. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Jim Dehner Apr 26, 2018 7:31 AM (in response to John Haselden)1 of 1 people found this helpfulHi john
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
Jim

2. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Shinichiro Murakami Apr 26, 2018 7:48 AM (in response to John Haselden)HI John
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")
Remove duplication.
filter only "true"
Thanks,
Shin

tableacalcsample_SM_10.5.twbx 17.3 KB


3. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
John Haselden Apr 26, 2018 10:44 AM (in response to Shinichiro Murakami)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?
Thanks again,
John

Dummy File.twbx 19.8 KB


4. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Shinichiro Murakami Apr 26, 2018 12:05 PM (in response to John Haselden)Hi John
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.
Shin

5. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
John Haselden Apr 26, 2018 12:19 PM (in response to Shinichiro Murakami)Hey Shin,
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,
John

Dummy File.twbx 19.4 KB

7. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
John Haselden Apr 26, 2018 12:35 PM (in response to Shinichiro Murakami)Yes, sorry! You're correct. It should be 5,4,1,1,3.
John

8. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Shinichiro Murakami Apr 26, 2018 5:23 PM (in response to John Haselden)Just FYI
Sorry, I am totally messed up myself and put this on hold.
Thanks,
shin

9. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
John Haselden Apr 27, 2018 6:42 AM (in response to Shinichiro Murakami)No problem, thank you for the input so far!
John

11. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Yuriy Fal Apr 27, 2018 11:23 AM (in response to John Haselden)Hi John,
Same old trick  using a pair of 'magic' RANKbased calculations
to count the number of Marks in each Table Calcbased 'bin' (Size)
and to show only one Mark for each 'bin' on a view (Filter).
Please find the attached.
Yours,
Yuri

Dummy File_v10.5_YF.twbx 35.7 KB


12. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Shinichiro Murakami Apr 27, 2018 5:21 PM (in response to Yuriy Fal)Thank you, Yuri,
Yes, I remember you mentioned this before, but could not find that post.
Your following up is always very helpful.
Thanks !!!
Shin

14. Re: How to use table calculation as basis for aggregation (The table calculation for X requires a field that is missing.)
Yuriy Fal Apr 30, 2018 6:58 AM (in response to John Haselden)Hi John,
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?
Yours,
Yuri