Group by date using magic ETL
Hi,
I am using Magic ETL to group my data by date. There are only 2 columns in my table: date and revenue. I want to group the revenue sum by date. Is it possible to do so in DOMO?
Thank you!
Best Answer
-
Good afternoon,
Using the Magic ETL Group By Tile you should be able to acheive this. It will ask you the column you want to identify the grouping which would be your date. You then would name the new aggregated column. Select your revenue column as the column to aggregate and the aggregate selection would be sum.
Let me know if this works for you.
1
Answers
-
Good afternoon,
Using the Magic ETL Group By Tile you should be able to acheive this. It will ask you the column you want to identify the grouping which would be your date. You then would name the new aggregated column. Select your revenue column as the column to aggregate and the aggregate selection would be sum.
Let me know if this works for you.
1
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
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive