Beastmode Help: Determine if order is <= $50,000
I've got a dataset that contains order data at the line item level. An order could have 1, or many items. I need to create a flag column that indicates if the total order value is <= 50,000. Would like to do this with a Beastmode if possible.
The unique identifier in this case is the order number, and the extended price is the column that contains the value for each item on the order that needs to be totalled to calculate the total order value.
Example attached.
Thanks in advance for your help!
Best Answers
-
I absolutely get where you are going with the ask. In order to filter and search on that flag, I'd recommend that you run your dataset through a Magic ETL DataFlow and use a window function to partition based on the unique order number, like you mentioned. You can find documentation for that here- https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window
This will add on another column on your dataset that will tell you that total. Then you can build a simple case statement to flag based on that $50,000 rule.
2 -
@GTA thanks again for the feedback. I have inplemented the solution you offered.
Here is a short video overview of how I implemented the Window function in case others want to see this in action.
0
Answers
-
Thanks for the quick reply!
Really hoping to find a solution for this with a Beastmode. Would be a much faster solution to implement if it's possible.
1 -
Great seeing you in ATL and thank you for making the drive down!
This is great!!
CC: @tallbaldfilmguy @hrh514 from our Domo Edcuation team
Dani aka "Mr.Dojo"
Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
**You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.0 -
Hi
You could use a Beastmode but it would not work unless you group by Order on the card (like the second box on you xls example.
Case when sum($) > 50000 then 'Yes' else 'No' end
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 ひらめき共有