Min(Date) function in Magic ETL to create a "Date of First Sale"?
Our client wants us to create a dataflow in Magic that includes a "date of first sale" column. In Redshift, we're able to perform a min("1st sale") calculation, but we're not able to find a way to perform this function within Magic ETL. The client has expressed that being able to use Magic is critical to them, so we really need to figure out a solution. Any ideas would be greatly appreciated.
Comments
-
You can do that in beastmode or on, for example, a table card; why Magic? That sort of aggregation work is frequently done on the card level, unless it's a step in a longer process.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
You can do it using the "Group By" tile. You will need to group over the whole dataset, i.e. the Group By column will need to be something like the _BATCH_ID, which is usually the same across the full source dataset.
The function then of the Group By tile is Minimum, and you applying that function over the column from whick you would like to extact the minimum, e.g. Date.
See the below screenshots. Hope this helps!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive