5 Replies Latest reply on Mar 26, 2020 5:18 AM by Raul Fortes

    Percentage of total from different measures using Table Calculation

    Raul Fortes

      Hi,

       

      I'm starting to build my first reports with Tableau. This is actually my first forum post

       

      I have a table with the following data:

      Dimensions: channel_name, date

      Measures: total regs, total non regs, rev regs and rev non regs, total_users (calculated field = regs + non regs)

       

      Just trying to make a column chart that represents the percentage of regs and non regs for each channel and show the corresponding "rev" for each segment. Since I have regs and no regs in different channels I cannot figure out the way to do it.

      Not sure whether I should reshape my table or what.

       

       

      If I use calculated fields:

      % regs: SUM([Total Regs])/SUM([total_users])

      % Non regs: SUM([Total Non Regs])/SUM([total_users])

       

      I cannot place the labels of rev because it will replicate the rev field across all segments (see screenshot):

       

      And if I use Table Calculation, well I just don't see how to do it

       

      I'm attaching the workbook. It's contains random data. I hope is the right format

       

      Any ideas? or do you know any other post with a similar question. I haven't been able to find it

       

      Many thanks!!

      Raul.