Fixed Function At Two Levels (Or nested Fixed Function)
I have a data set that includes duplicate rows for products.
I'm using a fixed function to dedupe an aggregate sum of product prices because I only want one product row to contribute to the total.
The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID)
However, now I need to create a table that looks like this:
Store  Total Product Price  Total Price  Percent of Total 

A  100  300  0.33 
B  100  300  0.33 
C  100  300  0.33 
The challenge is that the Total Price calculation must be a sum of the total_product_price calculation that is fixed to the entire data set (including the deduplication in total_product_price performed by the Fixed Function).
Thank you in advance!
Best Answer

Have you tried using nested beastmodes? You may need to have nested beastmodes enabled by your CSM from Domo. You could try SUM(DISTINCT Price) FIXED (BY Product ID) as Beastmode 1 and then:
SUM(SUM(`Beastmode 1`) FIXED ())
If I solved your problem, please select "yes" above
0
Answers

Is ETL out of the question?
If I solved your problem, please select "yes" above
0 
@ColemenWilson , it is the plan right now, to group the values and dedupe there, but that will lock us into a those set aggregation fields and prevent responsive filters.
After hacking, I wasn't able to get the fixed function to work as we'd like.0 
Have you tried using nested beastmodes? You may need to have nested beastmodes enabled by your CSM from Domo. You could try SUM(DISTINCT Price) FIXED (BY Product ID) as Beastmode 1 and then:
SUM(SUM(`Beastmode 1`) FIXED ())
If I solved your problem, please select "yes" above
0 
@ColemenWilson  I will try this. It's actually what I thought of as I typed out the OP.
Thanks, I'll follow up if it works!0
Categories
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 286 Workbench
 4 Cloud Amplifier
 7 Federated
 2.8K Transform
 91 SQL DataFlows
 585 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 649 Beast Mode
 37 App Studio
 33 Variables
 633 Automate
 161 Apps
 432 APIs & Domo Developer
 38 Workflows
 2 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 377 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 4 Software Integrations
 104 Manage
 101 Governance & Security
 6 Domo University
 21 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 93 Community Announcements
 4.8K Archive