0

I am working on Tableau Line chart with dual axis. However, I want to add dimension in those line chart and arrange by alphabet. Please see the link here to download the packaged workbook. What I wanted to do is as follow:

enter image description here

Can anyone advise me? Thanks Zep

Zephyr
  • 1,332
  • 2
  • 13
  • 31

1 Answers1

0

Only way that I can think is to use the dashboard.

Created one more sheet with names in team and then added both sheets in dashboard, For color coding I would suggest you to define your own colors for all teams and add in both the sheets.

take file from this link

Siva
  • 9,043
  • 12
  • 40
  • 63
  • Dear Siva. Thanks for your help.If I want to sort the teams based on the rank of GW 1. How can I do it? Thanks – Zephyr Sep 04 '18 at 12:06
  • @Zephyr are you able to achieve the requriement? – Siva Sep 04 '18 at 13:41
  • @Zephyr can you post answer and then accept it, so that others can use. Also, its good practice to close the thread – Siva Sep 04 '18 at 13:55
  • Here is what I did to rank the team. Create a calculated field (GW1Rank). The code is as follow: If [GW]==1 then [Rank] else 0 End – Zephyr Sep 04 '18 at 14:23
  • @Zephyr if my answer helped you then only accept it, Else please post your response as another answer and then accept your own posted answer – Siva Sep 04 '18 at 14:25
  • I think I hv accepted it. Thanks Siva for your help – Zephyr Sep 04 '18 at 14:31