Nested fixed functions
Hi All -
We are using fixed functions to calculate the average LTV per year for certain audiences. In the end, we want to be able to sum up the averages into a total 4-year LTV for the audience, which requires another fixed function. However, we're hitting errors when we wrap our calc in the new fixed function to sum up each of the averaged values. We've rewritten the calc so as not to reference any other beast modes, in case that was the issue, but still getting an error. Has anyone done anything similar successfully in a beast mode? Is there an issue with nesting fixed functions this way? Thanks!
Best Answer
-
Or…avoiding nesting fixed functions:
sum(
sum(Total LTV) fixed (by Year, Dimension 2, Dimension 3)
) /
sum(
sum(Total Orders) fixed (by Year, Dimension 2, Dimension 3)
)** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
@Sean_Tully Could you please share the current fixed function you're using?
0 -
It's something like this:
sum(SUM(
Total LTV
) fixed (byYear
,Dimension 2
,Dimension 3
))
/
sum(SUM(Total Orders
) fixed (byYear
,Dimension 2
,Dimension 3
))0 -
What is the error you are receiving? Without the error message it's a bit hard to pinpoint the issue.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Yeah, sorry, it was just the generic 'This calculation contained a syntax error' message in the beast mode, but we've had a few eyes on it and rewrote it piece by piece and we don't see any problems with the syntax, other than maybe nesting the fixed functions within each other throws the error. In the end it looks like this:
sum(sum(
sum(SUM(
Total LTV
) fixed (byYear
,Dimension 2
,Dimension 3
))
/
sum(SUM(Total Orders
) fixed (byYear
,Dimension 2
,Dimension 3
))) fixed (by
Dimension 2
,Dimension 3
))0 -
Perhaps you could try something like this, wrapping the entire calculation in another fixed function:
sum(
sum(
sum(Total LTV) fixed (by Year, Dimension 2, Dimension 3)
) /
sum(
sum(Total Orders) fixed (by Year, Dimension 2, Dimension 3)
)
) fixed (by Dimension 2, Dimension 3)** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Or…avoiding nesting fixed functions:
sum(
sum(Total LTV) fixed (by Year, Dimension 2, Dimension 3)
) /
sum(
sum(Total Orders) fixed (by Year, Dimension 2, Dimension 3)
)** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I accepted @ArborRose's answer. We found a way to what we needed without using the fixed function, though not in the same way - we used case statements for each year and added those up rather than the nested fixed function.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive