Creating a Distinct Column Name and Showing Last Completed Order
Scenario: There are thousands of customers that are placing orders on a daily basis, which include repeat customers.
I am trying to build a card that will:
1) Show the customer's name once on my card
2) Show the last time they placed an order.
Is there a way to make the 'CustomerName' column a unique value without creating beast mode? If not, then I could not find any distinct function other than 'Count Distinct' and 'Sum Distinct' which does not give me the customer's name.
Thank you for the help!
Best Answer
-
works as anticipated. with just Min and Max(date)
if this isn't the result you're getting, make sure you don't have anything in the ORDER / SORT clause that would be changing the cardinality expressed.
Jae Wilson
Check out my Domo Training YouTube Channel
**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"0
Answers
-
I think you could just put Name on the axis and create a MAX(Date) in a Beast mode.
Jae Wilson
Check out my Domo Training YouTube Channel
**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"0 -
Hi Jae,
Is there a way I can remove duplicates from my name column? When I added a beast mode column with max(date), it essentially is the same as an existing CompletedDate column. I think it's because there are duplicate customer names with multiple orders.
0 -
Upload a Sample dataset that spans these duplicates you're returning to. It's 1AM over here ? but I'll see if I can't get you something for tomorrow.
you can email me directly at [email protected] or DM me in the Global Slack Channel
Jae Wilson
Check out my Domo Training YouTube Channel
**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"0 -
Thanks Jae!
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 ひらめき共有