Group by date using magic ETL

Reply
Highlighted
Yellow Belt

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!

 


Accepted Solutions
Green Belt

Re: Group by date using magic ETL

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. 

 

2019-11-06 12_58_13-Domo.png

 

Let me know if this works for you. 

 

View solution in original post


All Replies
Green Belt

Re: Group by date using magic ETL

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. 

 

2019-11-06 12_58_13-Domo.png

 

Let me know if this works for you. 

 

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!