-
1. Re: Action Filter and Network Connections
Shinichiro MurakamiDec 15, 2016 6:07 PM (in response to Kazumi Nozawa)
1 of 1 people found this helpfulKazumi san,
I don't think this is a problem of action filter, but issue is on data structure.
This requires data restructuring to make filter work on relationships dashboard.
Because when you filter "8076", that filter loses the address of "8076" itself.
V1 - V2
8076-5145 (5145's address)
8076-50374 (50374's address)
5145-8076 (can not captured by filtering V1)
50374-8076 (can not captured by filtering V1)
So here is my approach to duplicate the data with Vertex ID1 + Vertex ID 2.
With this union, you can get
Solution
Vtex Union V1 V2
8076 8076 5145 (from 1st data=5145's address)
8076 8076 50374 (from 1st data = 50374's address)
8076 5145 8076 (from 2nd data =8076's address)
8076 50374 8076 (from 2nd data = 8076's address)
[Vertex ID Union]
if [Table Name]="Sample.csv" then [Vertex ID 1] else [Vertex ID 2] end
[Connection Count]
countd([Relationship])
It's OK to set first action on dashboard (from list to circle)
But from circle to relationships, need each dimensions, so filter does not work with this structure, I believe.
Instead, because we already filtered, create URL link on circle directly.
I believe you publish this dashboard, then you can type the URL of relationship dashboard.
Hope this helps.
Thanks,
Shin
-
2. Re: Action Filter and Network Connections
Shinichiro MurakamiDec 15, 2016 9:59 PM (in response to Shinichiro Murakami)
1 of 1 people found this helpfulI said wrong.
The second action also works if you put Vertex Union as dimensions.
And you can hide the header.
Thanks,
Shin
-
3. Re: Action Filter and Network Connections
Kazumi Nozawa Dec 16, 2016 3:11 PM (in response to Shinichiro Murakami)Ohayou gozaimasu, Shin san.
Thank you so much for your kind reply. It worked very well!
I understand your example, filter loses the address of "8076" itself. I am curious why we need to use "Union" instead of just creating a calculated field for the "vertex union"? I would like to understand more about the union data structure.
Sincerely,
Kazumi
-
4. Re: Action Filter and Network Connections
Shinichiro MurakamiDec 16, 2016 4:44 PM (in response to Kazumi Nozawa)
-
5. Re: Action Filter and Network Connections
Kazumi Nozawa Dec 19, 2016 10:49 AM (in response to Shinichiro Murakami)Hi Shin san,
Thank you for your response about the Union.
I created a calculated field to add one column called "Table Name":
'Network'
I also created a calculated field called "Union Vertex":
IF [Table Name]='Network' then [Vertex 1] else [Vertex 2] end
After that, the second filter action worked correctly as using Union.
Thank you again for your help.
Sincerely,
Kazumi
-
6. Re: Action Filter and Network Connections
Shinichiro MurakamiDec 19, 2016 10:57 AM (in response to Kazumi Nozawa)
Kazumi san
Thank you for the update.
Happy to know I could help you!!
BTW, it's rare to see Japanese Name on this forum, where do you work at?
Best regards,
Shin
-
7. Re: Action Filter and Network Connections
Kazumi Nozawa Dec 19, 2016 11:02 AM (in response to Shinichiro Murakami)Hi Shin san,
I work in Los Angeles, California. We've been using tableau since March, 2016. Where do you work at?
I agree that not many Japanese people are using this forum, but I think the forum is very helpful!
Sincerely,
Kazumi
-
8. Re: Action Filter and Network Connections
Shinichiro MurakamiDec 19, 2016 11:10 AM (in response to Kazumi Nozawa)
1 of 1 people found this helpfulKazumi san
I'm in Boise, Idaho.
Actually still language is pretty big hurdle for many Japanese people and the Forum in Japan Japan is used for "Japanese" Q&A.
If you have time and help answering the questions in Japan forum, it's also helpful.
That forum also has good questions / similar questions.
Only 250 people registered on that forum and traffic is 1/100 of this forum.
Thanks,
Shin
-
9. Re: Action Filter and Network Connections
Kazumi Nozawa Dec 19, 2016 11:55 AM (in response to Shinichiro Murakami)Hi Shin san,
Thank you for letting me know about the Japanese Tableau forum. It's good to know!
Sincerely,
Kazumi
-
10. Re: Action Filter and Network Connections
Kazumi Nozawa Dec 26, 2016 9:46 PM (in response to Shinichiro Murakami)Hi Shin san,
I was playing with your workbook and came up one question.
When I added one field called rank, it showed all connected network ranks.
I would like to show only the Vertex Union's rank.
I then created another workbook. Although this workbook seems fine showing only Union Vertex's rank, the second action does not work anymore.
Would you mind take a look at my workbooks when you have a chance?
Thank you and happy holidays.
Sincerely,
Kazumi
-
12_27_2016 Network.twbx 335.4 KB
-
-
11. Re: Action Filter and Network Connections
Shinichiro MurakamiDec 29, 2016 1:27 PM (in response to Kazumi Nozawa)
Kazumi,
You can use
[Rank 2]
{fixed [Vertex Union]:
max(if {fixed [Vertex Union],[rank]:countd([Relationship])}>1 then [rank] end)}
Have good rest of holidays.
Thanks,
Shin
-
12. Re: Action Filter and Network Connections
Kazumi Nozawa Jan 3, 2017 3:19 PM (in response to Shinichiro Murakami)Shin san,
Happy new year! Thank you for your reply. I understand your method that fixing a vertex union, counting distinct relationship, and showing rank as maximum number of those distinct values. This works! Thank you again for your kind help.
Sincerely,
Kazumi
-
13. Re: Action Filter and Network Connections
Shinichiro MurakamiJan 3, 2017 3:52 PM (in response to Kazumi Nozawa)
Happy new year to you.
Sounds good.
Thanks,
Shin
-
14. Re: Action Filter and Network Connections
Kazumi Nozawa Jan 16, 2017 3:49 PM (in response to Shinichiro Murakami)Hi Shin san,
I have another question regarding a network diagram.
If I would like to only show the connected list (showing the connected vertex IDs and not showing vertex unions). Is there any good way to filter it out using calculations? In that case, I would like to show rank as vertex ID2 rank, not Vertex Union rank.
I tried to use your method above by following formula:
{fixed [Vertex ID2]:
max(if {fixed [Vertex ID2],[rank]:countd([Relationship])}>1 then [rank] end)}
but it didn't worked.
I appreciate your kind help.
Sincerely,
Kazumi