3 Replies Latest reply on Sep 1, 2016 6:29 AM by Kathryn Bridges

Add %age column

Prem Kumar Aug 28, 2016 10:15 AM

I want to add a %age column in the column shelf next to individual calculated values.

Please see that the On Time is a calculated field having Before, After & On Time column values with Forecast %age and the Forecast Value one below the other. Is it possible to have the Forecast %age in the column fashion for every column. That is,

I want the Text Table to look like this.

Quarter Before Before% After After% On Time On Time%

Current Qtr $54.73 38.12% $88.85 61.88%

Next Qtr $7.82 1.63% $52.69 11.01% $418.20 87.36%

Prior Qtr $20.74 18.53% $91.20 81.47%

Can anyone please help me on this.

1. Re: Add %age column

Kathryn Bridges Aug 29, 2016 7:43 AM (in response to Prem Kumar)
Hi Prem,

What I would suggest is creating calculated fields for these percentages (Before %, After %, and On Time%).

Once these are created, you can drag "Measure Names" to your columns to separate them out.

Please see attached workbook for example.

Thanks.

MeasureNamesColumns.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
2. Re: Add %age column

Prem Kumar Aug 31, 2016 10:59 PM (in response to Kathryn Bridges)

Hi Kathryn,

Thanks for your reply with an attachment. I'm using version 9.2 and hence, unable to use your example.

Thank you,
Prem
Like Show 0 Likes(0)

Actions
3. Re: Add %age column

Kathryn Bridges Sep 1, 2016 6:29 AM (in response to Prem Kumar)
I've updated in 9.1. Please find attached.

This is using Superstore data, so in your data, you'll probably need to put a little more logic in the "% of Total Calculations" (Something like, "If [OnTime] = "Before" then [Forecast] else null end" for each time period, and then doing a Table Calc of Percent of Total on those.

Thanks!

MeasureVallueRows.twbx 1.2 MB
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Add %age column

1. Re: Add %age column

2. Re: Add %age column

3. Re: Add %age column

Actions

More Like This