12 Replies Latest reply on Dec 2, 2019 9:58 AM by shruten parmar

My percentages are 1918472%, which is abnormal. How would i change this to 19%? Hi Sook - Young,

Instead of dividing the values and then summing up, first sum and divide.

For Example

You are doing : [Sales]/ [orders] and then summing up

Do : Sum([Sales])/Sum([orders]) then keep this calculated field into marks card as AGG([Value])

Thanks,

Shruten

I am sorry, I am new to Tableau and do not understand the syntax/commands you have suggested.

I think we'll need to see a sample workbook so we can see how you've done the calculations.

I actually have not done any calculations except for these:

1. Cohort Score (All)

{FIXED [Competency Area]:AVG([Student])}*100

1. Student Score

[Student]*100

No Worries!

Can you please tell me what is the calculation for Cohort Score and Student score?

If you are doing any operations (sum,subtract,division or multiplication)  between two fields. First use "Sum" Function before the field.

Please let me know this helps.

Thanks,

Shruten

The problem is that we don't know what any of this means without the context of the workbook. Any chance you could mock up some sample data and share the workbook with us?

Shruten,

I am sorry, I do not know the calculation for these scores other than the ones I indicated in my reply above...

And I am not using any operations between the two fields. I am open to any and all suggestions

Ken,

By the workbook, would you mean the data source?

I mean the Tableau Packaged workbook--the twbx file. Packaged Workbooks - Tableau

Hi Sook-Young,

Step 1 - Change the formula into :

1. Cohort Score (All)

{FIXED [Competency Area]:AVG([Student])}

1. Student Score

[Student]

Step - 2 Do formatting to Number(Custom) Format <- And keep two decimal places <- and add % into suffix,  please refer the below image. Let me know if this helps.

Thanks,

Shruten

2 of 2 people found this helpful

Dear shruten parmar,

It did help the decimal places go way down.

I realized my problem, however, is this:

I have several (3~8) items for each competency area (A--- has 3 questions in the survey, for example).

I need the AVERAGE for the three items .... and all this for each competency area.

Would you happen to know how to do this?

Thank you. Hi Sook-Young,

You can use directly Avg function to get the average values. If this doesn't get you the values as expected use the LOD Function Fixed/Include.

Let me know if you need anything for this.

Thanks,

Shruten