8 Replies Latest reply on Sep 28, 2018 3:15 PM by Don Wise

# Likert Scale - Total Percent Sizing Issue

Almost DONE, BUT......

I am having an issue in calculating the total percent sizing issue, it is all 100%!

This tutorial has helped me a lot ,LIKERT SCALE TABLEAU TUTORIAL - YouTube

but still could not figure out how to solve it.

Plz find attached file , and let me know what is your thought in this?

• ###### 1. Re: Likert Scale - Total Percent Sizing Issue

Hello Samar,

Looks like the Table Calculation needed to be set to compute correctly for Percent of Total Sizing.  See if the below screenshot and newly attached (2018.2) workbook works?  Thx, Don

• ###### 2. Re: Likert Scale - Total Percent Sizing Issue

I am still having an error with the Gantt Percent!

I thought if I fixed the total percent sizing issue , it will be resolved .

Any thoughts to share?

On Sun, Sep 9, 2018 at 9:41 PM Don Wise <tableaucommunity@tableau.com>

• ###### 3. Re: Likert Scale - Total Percent Sizing Issue

Hi Samar,

Yes, same issue and solution as before.  A Table Calculation resolves it to match your visual. Please see below and newly attached workbook.  If this resolves your issue, please mark this response as correct so that others may find it useful in the future.  Thx! Don

1 of 1 people found this helpful
• ###### 4. Re: Likert Scale - Total Percent Sizing Issue

Hello Samar,

Just circling  back to see if your question was answered?  If yes, please mark this response as correct to close the thread.  Thanks, Don

• ###### 5. Re: Likert Scale - Total Percent Sizing Issue

Hi Don,

I also have some trouble while trying to build a Likert scale. I have or had the same issue with the Gantt Percent (which was computed from -100% to 300%).

I couldn't find the "Table calculation" menu that you describe (Mac OS X; 2018.2). But a double click on the left "Measure-column" forced a new computation.

BUT: as you can see - the values of Gantt Percent for the first question are right, but for the second question not. It seems there is no "reset" and the percentages will be counted up!

The file is attached.

Could you help me please? Thank you very much!

Joern

• ###### 6. Re: Likert Scale - Total Percent Sizing Issue

Hi Don,

I finally found the "Table Calculation" - and I solved my problem with the correct computation of the Gantt Percentage.

But when I now try to build the Gantt chart, the layout and the scale does not fit (scale is not in percentage).

Do you know what went wrong?

Thank you very much,

Joern

• ###### 7. Re: Likert Scale - Total Percent Sizing Issue

Done! Forgot to activate the "Gantt bar" mode! Thx

/Joern

• ###### 8. Re: Likert Scale - Total Percent Sizing Issue

Hi Joern,

That's great! Could you please close this thread by marking my original response as correct? Thanks, Don