1. After I posted an article yesterday on seamless sheet swapping, I remembered I had found something interesting a while ago regarding the sheet swapping of packed bubble chart. The problem was that, one can't filter the packed bubble chart completely using the sheet selector.

    The cause of the problem is due to no pills on Rows/Columns shelves. These are the gridless chart types. The solution was to add some "Blank" dimensions to Rows/Columns and thus the problem got fixed. Remember to right click the Blank dimension and un-check "Show Header".
    Click this picture to go to the interactive version.
    As sheet swapping gets popular, similar problems came up often:

    The above technique applies to all the chart types with no rows/columns pills: Packed Bubble, Pie and Treemap etc.

    Note that in this thread, Zen Master Jonathan Drummey mentioned that he has long found the issue and its solution. He even posted an idea in as early as 2011, which still remains active:

    Hope this idea gets implemented one day. Before that day, we have to live with the above tricks.
    9

    View comments

  2. [Updates on the technique:
    1. Seamless Sheet Swapping with Containers
    This fixes the problem of displaying tooltips in lower worksheets.
    2. Sheet Swapping with Pie/Tree Map/Packed Bubble Charts
    It shows how to turn on/off gridless charts in sheet swapping.
    ]

    In this blog, we propose an approach that solves the problem of sheet alignment, no matter how many sheets you have.

    Sheet swapping/selecting is an interesting technique that has broad applications. In short it allows us to display multiple sheets on one canvas, one at a time. It provides a good alternative to the story points and enables various display options. A big advantage over story points is one can use global filters.

    A popular approach to it is using a container and dropping all the sheets into the container. Each sheet is set to the Entire View. The problem is, although one sheet is shown at a time, we still see the ghost of the remnants of the other sheets. It takes extra spaces at the top and the bottom of the container. The sheets will shift up or down when selected. The effect is quite visible to human eyes and looks annoying.

    Here we propose a containerless approach without the shifting issues. The steps are as follows:
    1.Set up the selector as a parameter which is described here
    http://kb.tableau.com/articles/knowledgebase/creating-sheet-selector-for-dashboard
    In my example, I assigned the parameter values as 1,2,3. The descriptions are Line, Bar and Circle.

    2.Create a filter and set it up as described in the above KB article.

    3.Drag all the sheets to the dashboard in Floating mode. Set them to entire view and turn on the selector. No container please.

    4.In the Layout Manager (lower left corner), set up the position for each of the 3 sheets the same:
    x=0;y=0;w=800;h=600. Move the Chart Selector to the top.
    That's it. You will save yourself from the worrisome sheet alignment issues.  Click the following image to go to the interactive version.
    In the container approach, it saves us a few steps of positioning the worksheets. But it causes us the pain of misalignment. In our approach, we position every chart the same, which is a bit manual but repetitive. Not a bad exercise though. The charts thus positioned are exactly on top of each other without a single nano-meter of shift.

    Similar approach is applied to a recent viz where the selector is based on action filters. Check it out here:
    http://vizdiff.blogspot.com/2016/02/tableau-ambassadors-2016.html
    7

    View comments

  3. Recently some of the our tableau users reported issues like this:
    "Internet communication error: Peer certificate cannot be authenticated with given CA certificates."
    Thus they can't connect to the Tableau Server to publish their work.
    The Tableau knowledge base article doesn't seem to help:
    http://kb.tableau.com/articles/issue/error-peer-certificate-cannot-be-authenticated-with-given-ca-certificate-online-tableausoftware-com

    Here is a solution from our IT folks.

    1.Open your Tableau server site URL in IE. Click on the "LOCK" sign to the right side.
    2. Click on the "View certificates" to open the certificate for the Tableau server.
     3.Click on "Install Certificate"
    4.Select the folder "Trusted Root...." and OK.

    This should solve your login problem and enable you to login into the server. What this did is to make this site a trusted place to visit.

    1

    View comments

  4. Sexual discrimination does exist. California is no exception. We have data to prove it. There are man diseases and woman diseases. Some of the diseases are predominantly in men and others are more in women. But the distribution by gender varies depending on counties and years.

    Following two previous posts:
    Infectious Diseases in California 2001-2014: Trends
    Infectious Diseases in California 2001-2014: Top Diseases and Counties

    I added 2 more views to show the gender distribution in every disease and in every county in California from 2001-2014.

    Chlamydia is mostly predominantly in women in all the counties except San Francisco where there are more men infected than women. It is such a revelation. There must be something to do with the local dating pattern, dare I say.

    Click on the image to turn on interactivity and find out more. Feel free to share with people of interest.


    0

    Add a comment

  5. In the previous post, we showed the trends of 65 infectious diseases in California's 58 counties from 2001-2014.

    Here we added two views on top diseases and top counties which can be further segmented by year and gender. It took time to think and create various views. I feel it makes sense to post them as I create them.

    I am a little surprised that Kern county got the top prevalence in chlamydia in 2014! In San Francisco, the top 3 infectious diseases are all STDs and predominantly male!

    Click the images to turn on interactivity.

    This post is followed by 

    0

    Add a comment

Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.