Weighted Average Price Beast Mode
Hi Everyone,
I am working on creating a beast mode that will calculate a weighted average price of subscriptions. Essentially, the formula will take the subscription price and multiply it by the number of subscriptions with that price, then divide by the total number of subscriptions.
This is what I have so far.
sum(count(`subscription_id`) * `price`)/count(`subscription_id`)
Love to get some help! I don't want to use a "case" statement because there are over 600 prices that I am working with in my dataset.
Thanks
Answers

Hi @jgillman
You'll need to aggregate your data and count all of the subscriptions before attempting to calculate the weighted average. You can't aggregate an aggregate in a beast mode so preaggregation is required.
Once you have the number of subscriptions counted you can then use that new field in your beast mode to calculate the weighted average
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
If you don't have window functions in beast mode enabled, you will need to get that enabled by your CSM. Then, if you add the OVER() clause to your denominator, you will be able to get a count of your total number of subscriptions. Like this:
sum(count(`subscription_id`) * `price`)/count(`subscription_id`) OVER()
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
 11K All Categories
 5 Private Company Board
 2 APAC User Group
 12 Welcome
 42 Domo News
 9.9K Using Domo
 2K Dataflows
 2.5K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 349 Workbench
 266 Domo Best Practices
 11 Domo Certification
 474 Domo Developer
 51 Domo Everywhere
 110 Apps
 725 New to Domo
 85 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 28 お知らせ
 65 Kowaza
 301 仲間に相談
 662 ひらめき共有