Hi team.,
Below are the Formatting issues which I am facing related to my MakeoverMonday Week 32 Viz
Hi Rajeev,
I guess you've already tried this. Give a try and let me know If this help.
Mahfooj
Thanks buddy . I did try this approach but it didnt work for me.
Thats why I created a Fake axis and added the Label on text so that it will appear at the top.
Can you please download my workbook and try your alternatives/techniques
Aug 13, 2016 4:38 AM
So the problem here (as I think you've noticed) is that not all countries competed (or won Gold/Silver medals...as per your filter) at the 1960 Olympics...as so your Ref Line formula won't have an assignment for those countries. I have a "kind of" solution. I say "kind of" as it doesn't place all the country labels in the same place. This is due to there not being data-points (countries not completing/not winning medals) for certain/country year combinations.
I've used Gannt marks (which I've then set the transparency to 0%), as this gives me more control over the labels and then (like Mahfooj) have used the MIN/MAX to only return me one value. I've also changed your RefLine to the value 250 (so all countries get a mark). If you were to re-shape your data, and by this I don't actually mean change the shape! but create a row for every country/year combination (this is pretty easy in many packages - cross-join in SQL, VBA in Excel, or Pivot Table in Excel are some easy options)...and then LEFT JOIN your current data to this (joined on Year/Country) there would be a Row for every Year/Country combination (in which case your original method would work fine). This wouldn't change your main Viz as any countries with no medals for a Year would just have NULL in the Gold/Silver/Bronze measures....
Hope that helps.
Being at home unable to open your workbook. I'm using public version. However, I've done some label formatting and got this. Workbook has been saved in my profile.
I haven't used any ref-line just done label formatting.
Have a look. Tableau Public
Mahfooj
Aug 13, 2016 5:26 AM
very nice Mahfooj...very imaginative to change the Edition to Year, so that you could use 'Most Recent'
Mahfooj Khan ..Not sure, if i am looking it correctly. When i download the workbook and see the formatting like this. Is the formatting done only on Tooltip? I don't see the country names in the report as like what you showed in your previous post.
Madhu,
I am using the tableau 9.3 and I am able to see the viz, please let me know if you need any details.
Thank you so much my friend.Such a great Approach.
With You help I am able to complete my Viz.So I m dedicating this Viz to you.
Brother can you drop me an email(rajvivan11@hotmail.com) with your email id>
Hi Mahfooj, Could you please explain how you have resolved it ?
Sevvel, For some reason ..i am seeing a different image than what you all are seeing. I am using 9.3.5 by the way ..