3 Replies Latest reply on Dec 17, 2012 10:16 AM by Daniel Ruszaj

    How do I create a 2D frequency table with more than one column, to store a number of calculated statistics?

    Daniel Ruszaj

      Hi,

       

      On my row shelf I have 2 dimensions. In the mark shelf I have CNT() of the measure equivalent (unbinned version) of one of those dimensions. This gives me a basic frequency report with a single column which shows me the count.

       

      My issue is I would like to show more than just the count. I'd like to show count, percentage of total, percentage of row, and percentage of column, in four columns side-by-side. Is this possible in Tableau? Here is an example of what I'm going for. The first two columns in the below table are dimensions, the rest are computed.

       

      Thanks for your help.

       


      acctBal_binlimit_bincountpctpctColpctRow

      0000.0000.0000.000

      0(0,500)00.0000.0000.000

      0[500,1000)00.0000.0000.000

      0[1000,2000)00.0000.0000.000

      0[2000,+)00.0000.0000.000

      0*m00.0000.0000.000

      0*e00.0000.0000.000

      (0,500)000.0000.0000.000

      (0,500)(0,500)393.900100.00095.122

      (0,500)[500,1000)20.2006.8974.878

      (0,500)[1000,2000)00.0000.0000.000

      (0,500)[2000,+)00.0000.0000.000

      (0,500)*m00.0000.0000.000

      (0,500)*e00.0000.0000.000

      [500,1000)000.0000.0000.000

      [500,1000)(0,500)00.0000.0000.000

      [500,1000)[500,1000)272.70093.10379.412

      [500,1000)[1000,2000)70.7008.75020.588

      [500,1000)[2000,+)00.0000.0000.000

      [500,1000)*m00.0000.0000.000

      [500,1000)*e00.0000.0000.000

      [1000,2000)000.0000.0000.000

      [1000,2000)(0,500)00.0000.0000.000

      [1000,2000)[500,1000)00.0000.0000.000

      [1000,2000)[1000,2000)737.30091.25083.908

      [1000,2000)[2000,+)141.4001.86216.092

      [1000,2000)*m00.0000.0000.000

      [1000,2000)*e00.0000.0000.000

      [2000,+)000.0000.0000.000

      [2000,+)(0,500)00.0000.0000.000

      [2000,+)[500,1000)00.0000.0000.000

      [2000,+)[1000,2000)00.0000.0000.000

      [2000,+)[2000,+)73873.80098.138100.000

      [2000,+)*m00.0000.0000.000

      [2000,+)*e00.0000.0000.000