Unique Customer Name and total spent
I'm trying to sort through a bunch of orders and get the customer name and the total spent for that customer. However, I have a customer name associated with each order. Meaning I can have 50 customer names. Same concept with the customer total spent. That information is totaled on each order row.
In short this is what I'm getting
I want only one unique row of:
UNFI - EAST 385,518.60
Can I do this in Beast Mode? I was having difficulty doing this in ETL
Thanks
0
Comments
-
Depending on the other data you have in there, you should be able to get unique values by aggregating the total spent column. If for every customer that value is always the same, then you can use an avg, min, or max function to do that.
Aaron
MajorDomo @ Merit Medical
**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"1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有