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 ❤️ 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 ❤️ 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 ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
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 ❤️ 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
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 508 Automate
- 114 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive