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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive