I met an issue that requires to show a cross tab table in full glory. However the default view may not be complete because of missing members in dimensions (Domain incomplete) and missing data.

Here is how the original data look like:

- There are only 4 valid data marks (Abc), out of possible 12.

- There are in total 3 possible events in the Event dimension. Neither of the two sites has 3 events. That is domain incomplete in each site. There are possible 6 columns if complete.

- There are blank spots with no data marks. We would like to fill all the blank spots with zeroes.

We will use two passes of densification to fill all the blank spots.

1.First pass: Domain completion 

Create an Index field (=index()) and drag it to the Detail shelf.
5

An alternative title could be "Highlighting without Ignoring the Rest of the Pack".

In a recent viz of the day, one member was highlighted against the rest. The rest was painted with the same grey color.

That doesn't show the rest of different players, which I found was not satisfactory. I felt that we still need to show that those are distinct players. I ended up by hand tuning the colors to make them in different shades of grey. The highlight of the chart remains intact.

Double congratulations to Rody Zakovich for being named a Tableau Zen Master of 2016-2017 and for winning the Viz of the Day on 9/9/2016! Rody deserves it absolutely! Rody has brought a great impact on the Tableau community in the last couple years, for which I am a witness.

In his latest viz, Rody has got a neat design for the tooltip. It has a well aligned box score table in it. Very delightful design!

When I saw the text table, I saw potential for further visualization.
2

We may need to reuse the same data sources times and again in one project. We may need to clone a data source in different workbooks. Helas, there is no copy-n-paste option for data sources. (Submitted a feature request and please upvote it if you like it.)

Saving a data source is an available option. But you may not want to have the connection information saved in a local tds file for security reasons. I feel copy-n-paste is a better option in many ways.

Most likely, one view of a dataset is not enough. Different graphical representations may have their own advantages and biases. Each would offer a partial set of insights from the dataset.

It would be good to have a few different representations so that we can view the dataset in complementary ways. This is likely to offer the viewers more insights. We are not talking about slicing or dicing here.
Blog Archive
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.