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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 257 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 501 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 375 Beast Mode
- 20 Variables
- 485 Automate
- 103 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive