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 the heart icon**
**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 like any users posts that helped you and accept the ones who solved your issue.**0
Categories
 10.6K All Categories
 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 338 Workbench
 250 Domo Best Practices
 11 Domo Certification
 460 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 62 Kowaza
 295 仲間に相談
 649 ひらめき共有