Chose the newest date available
Hi All,
I am working to combine two tables. The first step I need to take is to filter the project_number by with the newest report date available.
The example below shows two different project numbers
The first one has the last report date as Q3 2022 - we need to capture that input
The second project_number has q4 of 2022 - we need to capture that input as well.
Essentially, I need to capture the latest known input for each project id.
Can someone help me with the logic on this one?
I'm not sure which functions would be the most efficient for this process. Any suggestions?
If this helps, feel free to agree, accept or awesome it!
Best Answer
-
You can use a Rank & Window tile with a MAX aggregation to get the most recent date. You can partition by the project_number to get the latest date for each project.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
You can use a Rank & Window tile with a MAX aggregation to get the most recent date. You can partition by the project_number to get the latest date for each project.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive