Partitioning in Beast Mode not Working Properly
I am hoping someone can tell me a simple fix for why my beast mode calculation is returning an incorrect value. What I am doing is not too complicated, but it is not working and I could use some guidance because I am new to Domo.
I have created a column to show the total amount by Quarter using the following calculation:
This is working properly and yields the correct result, which is the total value of the Amount USD for that particular quarter based on the value in the Quarter ID column . However, I want to do this EXACT calculation, only I want the partition to be the PRIOR QUARTER, using the below calculation:
The problem is that the columns yield the SAME result and I have no idea why. See Below:
Quarter ID and Prior Quarter are not the same value FYI:
Any insight as to why this could be?
Best Answer
-
If the Quarter ID is "2019 Q4", is there ever any other Prior Quarter value besides "2018 Q4"? If not, then it's logical that the Total Amounts are the same since the same rows are being aggregated.
0
Answers
-
If the Quarter ID is "2019 Q4", is there ever any other Prior Quarter value besides "2018 Q4"? If not, then it's logical that the Total Amounts are the same since the same rows are being aggregated.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive