New User - Help with Filling Forward Previous Incident Date
I'm working with citation data for different locations and want to create a column called "Previous Citation Date" for each location. So far, in Magic ETL, I’ve filtered the data by the days a citation was issued and used the Lag function in the Rank Tile to get the previous citation date, partitioned by location. However, when I join this back to the dataset, it still leaves the challenge of how to fill forward the previous citation date for all the days no citation was issued for that location. I'm new to Domo and not sure how to go about this or if I'm approaching this in the right way.
Additionally, I’m trying to build a Single Value Card to show the number of consecutive days since the last citation was issued.
Would love any advice on the best way to approach this in Domo—thanks!
Answers
-
Hello @CRBrown,
Providing a sample of your data would be helpful. Based on my understanding of your request, you can use the 'Group' tile to find the MAX('Citation Date') for each location and then join it back to the main dataset.
For the second question, the following Beast Mode formula should meet your needs.
DATEDIFF(CURRENT_DATE(), MAX(
CITATION_DATE
))If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 653 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive