Moving Values One Row Down - Conversion Rates
Options
Hello! Does anyone know how to move the "Stage Count" column down one row (Stage Count 2) rather than erasing the top value? I am trying to get the Stage Count 2 column to read:
blank
3821
336
122
33
32
I attempted a LAG, but this version of mysql is too old to use I believe :(
Thanks,
Keirsten
Tagged:
0
Answers
-
@keeeirs10 Domo's MySQL is currently on version 5.6, which doesn't support lag. I would suggest using Magic ETL and using the rank & window tile and use the lag function in there. It will run very fast and is easy to put together. Here's the KB article on the rank & window tile if you haven't seen it.
https://domohelp.domo.com/hc/en-us/articles/360044876094-New-Magic-ETL-Tiles-Aggregate#3.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.3
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- 827 Beast Mode
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 46 Calculations & Variables
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- 122 Workflows
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- Automate
- 5K Archive