5 Replies Latest reply on Feb 12, 2016 7:05 AM by Yuriy Fal

# Calculating Weighted Score For Multivariable Group

I am trying to calculate Task Count per Order based on the following parameter (I want the calculation to be as shown "Task Count per Order" column).  Any ideas?

 Corporation Name Subsidiary Name Distinct count of order id Task Count Task Count per order Corporation 1 Subsidiary ABC 2 50 50/37 Subsidiary DEF 5 30 30/37 Subsidiary GHI 30 77 77/37 Total Corporation 1 37 157 Corporation 2 Subsidiary JKL 1000 8905 8905/1300 Subsidiary MNO 300 448 448/1300 Total Corporation 2 1300 9353 Corporation 3 Subsidiary PQR 200 908 908/392 Subsidiary STU 100 300 300/392 Subsidiary VWX 59 205 205/392 Subsidiary YZ 33 55 55/392 Total Corporation 3 392 1468
• ###### 1. Re: Calculating Weighted Score For Multivariable Group

Hi Noorani,

It could be like this:

SUM ( {EXCLUDE [Subsidiary Name] : SUM ( [Distinct count of order id] ) } ) / SUM ( [Task Count] )

If your [Distinct count of order id] is already an aggregation like COUNTD([order id]),

then you could remove the then unnecessary SUM( ) around it.

Hope it could help.

Yours,

Yuri

• ###### 2. Re: Calculating Weighted Score For Multivariable Group

Thanks Yuri!

• ###### 3. Re: Calculating Weighted Score For Multivariable Group

You're welcome.

If my answer looks like the right one to you,

you couldn't hesitate to mark it as correct :-)

Yours,

Yuri

• ###### 4. Re: Calculating Weighted Score For Multivariable Group

actually, I tried it and it is not working ... I am planning to create a

workbook to show all the moving pieces and then re-post it so it is easier

to follow what I am trying to do ...

On Fri, Feb 12, 2016 at 5:33 AM, Yuriy Fal <tableaucommunity@tableau.com>