Vizible Difference: Filling Blanks via Multi-Pass Data Densification

Vizible Difference: Filling Blanks via Multi-Pass Data Densification

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. Set the Index to compute using Pane (Across then Down). This will complete the domain for Event. Note that both sites have the same events and data mark distributions.

Filling Blanks via Multi-Pass Data Densification

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 member…

 

The following two tabs change content below.

Eric Axelrod

President & Chief Architect at DIGR
I have helped companies bring new data driven products to market, drive efficiency out of their supply chain, execute strategic plans, and drive top line and bottom line growth by enabling every business function with actionable analytics. I can transform a business which is lacking critical insight into an agile, strategic, data driven organization.

Leave a Reply