12 Replies Latest reply on Apr 27, 2018 9:09 AM by Santi Roberts

Sliders for pie charts on maps, long loading time

Santi Roberts Apr 25, 2018 10:14 AM

Hi,

Newbie here with what I hope is an easy set of questions to answer! I have data mapped as pie charts onto a global map background. Display and workbook attached or available here - you may need to click on the 'Recommendations by region maps (takes a while to load)' link if it drops you onto the menu. I have it broken into three separate maps at the moment because I haven't been able to come up with a single map that meets everyone's needs. So, currently it takes forever to load (and sometimes seems to fail), and the multiple maps seems an unclean way of doing what I want it to do:

Some mechanism, perhaps a slider, to allow the end user to control the size of the pies. I know it can be controlled within tableau using the 'Size' option in the 'Marks' box, but I haven't found a way to let the end user control this.
Some mechanism to allow the end user to select what geographic level they want the data displayed at (i.e. continent, region, or country). So, the user can select, say, continent, and the pie chart will display at the continent level (currently the top map in the display), and if the user wants pie at a more detailed level, they can select the region or country level.

Hopefully, this is clear! Any thoughts would be most welcome!

I'm currently using tableau public (the free one).

Thanks, Santi

adding this @ as Łukasz was very helpful for my last question! @Łukasz Majewski

SFW Global Mapping Project.twbx 2.4 MB

1. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 25, 2018 10:45 PM (in response to Santi Roberts)

I may have figured out how to do the pie size slider using this very useful post Alter Mark Size on a Map when Zooming . going to try and test out tomorrow .
Like Show 0 Likes(0)

Actions
2. Re: Sliders for pie charts on maps, long loading time

Peter Fakan Apr 25, 2018 11:49 PM (in response to Santi Roberts)
Hi Santi,

The reason your viz is slow is because it is trying to paint up so many data points. However, you can get an immediate performance gain by switching the maps to offline mode (Map > Background Maps > Offline).

I've also done a sheet-swap to show you how to switch between maps which gives the impression of improving performance.

HTH 10.5 attached. If you upload it, you should see demonstrably faster performance.

Peter

SFW Global Mapping Project.twbx 2.4 MB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 26, 2018 3:53 PM (in response to Peter Fakan)

Thank you Peter! this looks great in Tableau reader 10.5, but I cannot open it in Tableau public 10.5 due to the program wanting to open up a version that I must have been working on later than the one you uploaded (see message below from when I try and open the file). Changing the filename does not help. This happened in my last post to these forums too (my first ever), and I never figured out how to resolve the problem as he uploaded it to his public site, I downloaded it and it worked. Please let me know if you know how to disable opening the latest file, or upload to a place I can download from! sorry for the hassle.
Like Show 0 Likes(0)

Actions
4. Re: Sliders for pie charts on maps, long loading time

Peter Fakan Apr 26, 2018 4:04 PM (in response to Santi Roberts)

Hi Santi,

Sorry, I realised I was using TD 10.5.2.

I just loaded up the viz and it didn't allow me to export the file as a lesser version

Are you able to follow my directions above or upgrade to 10.5.2 ?

Peter
Like Show 0 Likes(0)

Actions
5. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 26, 2018 4:14 PM (in response to Peter Fakan)

Thanks Peter. i am working in version 10.5.3. I am not able to open the file because of the problem above (it just opens the one I was working on last night, which may be date stamped as 'newer' than the one you uploaded?). I took the message to mean it's opening the version of the file that is date stamped as most recent) rather than the version made with the most recent version of Tableau. I think if you upload and send me the link it might work (it did last time). I have also submitted an email to Support, so we'll see if they can figure it out. Thanks
Like Show 0 Likes(0)

Actions
6. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 26, 2018 4:39 PM (in response to Santi Roberts)

offline maps looks like it's only available for tableau desktop. https://onlinehelp.tableau.com/current/pro/desktop/en-us/maps_mapsources.html#maptiles. I'll work on my employer getting me a copy of that , but I'd still like to be able to use your revamped version of my workbook in the meantime. Thanks
Like Show 0 Likes(0)

Actions
7. Re: Sliders for pie charts on maps, long loading time

Peter Fakan Apr 26, 2018 5:15 PM (in response to Santi Roberts)
Hi Santi,

No problem, here's another go at uploading it - unfortunately the export as version is still greyed out for me.

HTH

Peter

SFW Global Mapping Project (3).twbx 2.4 MB
Like Show 0 Likes(0)

Actions
8. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 26, 2018 5:21 PM (in response to Peter Fakan)

Ah sorry Peter I have not been clear. I meant upload to your tableau public site from which I then download, rather than upload to this thread. That’s what worked last time. Thanks again.

Sent from my iPhone
Like Show 0 Likes(0)

Actions
9. Re: Sliders for pie charts on maps, long loading time

Peter Fakan Apr 26, 2018 5:29 PM (in response to Santi Roberts)

Ahh ok - https://public.tableau.com/shared/HJDQ7CCT4?:display_count=yes

Peter
Like Show 0 Likes(0)

Actions
10. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 26, 2018 10:41 PM (in response to Peter Fakan)

Yep that worked. It looks and works great. Thank you! I’ll figure out at some point how you did it :). I’ve also managed to get the pie chart resizing in the public site working by using the post I link to above.

Sent from my iPhone
Like Show 0 Likes(0)

Actions
11. Re: Sliders for pie charts on maps, long loading time

Peter Fakan Apr 26, 2018 11:00 PM (in response to Santi Roberts)

Hi Santi,

Glad to hear its working ok.

As I noted above, this is only an interim performance measure - there are better methods of making your maps faster but this was the quickest method of getting you up and running with reasonable load times for your maps. The sheet swap technique is pretty well documented, but as I also noted above this doesn't give any actual performance improvements apart from it just 'seems' faster.

Appreciate if you could mark the question complete on the most relevant post you think resolved your issue.

Peter
Like Show 0 Likes(0)

Actions
12. Re: Sliders for pie charts on maps, long loading time

Santi Roberts Apr 27, 2018 9:09 AM (in response to Peter Fakan)

Thanks Peter, done! Understood on the loading times.
Like Show 0 Likes(0)

Actions