Hello,
I would like to use action filters to dynamically filter dashboards.
1. Select one vertex ID from List (in this case, select vertex ID 40374)
2. Go to another dashboard, "Connections #" and select the circle
3. Show list of connected vertex IDs and network diagram.
Succeeded until the step 2, but I could not use action filter for step 3.
Attached a sample workbook.
Thank you,
Kazumi
Kazumi 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
I said wrong.
The second action also works if you put Vertex Union as dimensions.
And you can hide the header.
Thanks,
Shin
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
Kazumi san,
You are welcome.
I'm not sure about your idea of using calculated filed instead of union.
You may create below type of formula, but this requires "contains" 8076 thru different table or parameter.
I think that's more troublesome??
Thanks,
Shin
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
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
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
Kazumi 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
Hi Shin san,
Thank you for letting me know about the Japanese Tableau forum. It's good to know!
Sincerely,
Kazumi
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
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
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
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