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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 203 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive