Mikey, how do you get the 82.33 value?
How would be out of Tableau?
1 of 1 people found this helpful
You will need to setup a calculated Field to actually calculate the Weighted Average.
Looks like you want to have a weighted average of the open days.
You can first create a Field to calculate the Product of Open Days and Extended Payment Terms - Current
[Weighted Average]*[Extended pymnt terms - Current]
Then you can use this field to calculate the WeightedAvg
SUM([ProductTermsWtAvg])/SUM([Extended pymnt terms - Current])
Here is how you can plot the two at the same time
Fine. It's correct.