Sum One Check Amount with multiple rows of the same data by using DISTINCT ?
I am looking to ONE "CHECK AMOUNT" per distinct "first name" AND "check date".
the data source has multiple lines for the same check amount, but i only want to count one "check amount" per "first name" and "Check date"
this data is in DOMO but i just downloaded it to understand the layout of the data better.
Any Ideas ?
Answers
-
I assume this is data where you took a payment table and JOINed it to a Employee Timesheet table.
Don't JOIN the data.
Append, UNION, the two sets of data together.
I know it sounds like work to understand why UNION is a better solution than JOIN. But trust me.
As you JOIN transaction tables together, you are going to try to do more crazy math to make your cards work. It's not scalable.
Take your LEFT table, add "Activity Type" = "Payment"
Take your RIGHT table add "Activity Type" = "Timesheet"
And UNION the data on conformed column names. You'll avoid row duplication.
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"2
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive