Sum Orders, Line Count, Sales by day of the week (Friday, Saturday, and Sunday)

Hello, my dataset has 7 columns: Invoice date, location, orders, ... invoice total (see screenshot); I want to sum orders, line count, and sales by day; meaning January 21 2023 Friday's orders =DC 12 ATL's orders + DC 11 MOB's order = 65+0.
Friday's sales = DC 12's Invoiced total + DC 11's invoiced total = $10,932.39 + 0.
What I'm trying to create is to show 3 rows (Friday, Saturday, and Sunday) for SUM orders, line count, quantity, and sales.
Can someone please help me with this request?
Do I need to use a beastmode or ETL? Thank you so much for your help.
Answers
-
If you remove the Location and Location Number fields from your table and then in the column fields for your orders, line counts, quantity and sales amounts you can select SUM as the aggregation method. This will add all of the different locations together for each of your metrics.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 825 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 197 Apps
- 489 APIs & Domo Developer
- 94 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 12 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive