Beast Mode: Sliding Window Function with Partition?

Reply
Highlighted
Black Belt

Beast Mode: Sliding Window Function with Partition?

@jaeW_at_Onyx this is probably right up your alley with recent Dojo solutions and videos you have put together.  Please see my video linked below, and attached sample data.

 

https://youtu.be/Y21fV4t5kGk 

 

I have been able to do this with an ETL so for those that want to know how that is included in the video.  I would prefer to do this with a beast mode as my current data set is massive and the ETL takes a while to run.


Accepted Solutions
Highlighted
Major Red Belt

Re: Beast Mode: Sliding Window Function with Partition?

@swagner , we can acchieve this with the lag() function in Domo.

 

https://www.youtube.com/watch?v=cnc6gMKZ9R8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=6

 


Caveat, the LAG() function example in this video will be the last 12 entries.  So if there's a gap in days you'd have 'the last 12 entries' not 'the 11 entries in the past 12 days'.  To overcome that issue, you need a template row, one row per day, per productGroup with sale amount = 0.

 

Hope that helps!


Jae Wilson
Check out my Domo Training YouTube Channel

**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"

View solution in original post

How to create lag functions in Card #Analyzer using #BeastModes ##### CONSULTING SERVICES #### I have left Domo to start my own consulting company, #OnyxRepo...

All Replies
Highlighted
Major Red Belt

Re: Beast Mode: Sliding Window Function with Partition?

@swagner , we can acchieve this with the lag() function in Domo.

 

https://www.youtube.com/watch?v=cnc6gMKZ9R8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=6

 


Caveat, the LAG() function example in this video will be the last 12 entries.  So if there's a gap in days you'd have 'the last 12 entries' not 'the 11 entries in the past 12 days'.  To overcome that issue, you need a template row, one row per day, per productGroup with sale amount = 0.

 

Hope that helps!


Jae Wilson
Check out my Domo Training YouTube Channel

**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"

View solution in original post

How to create lag functions in Card #Analyzer using #BeastModes ##### CONSULTING SERVICES #### I have left Domo to start my own consulting company, #OnyxRepo...
Announcements
What is your Dojo rank and what badges have you earned? How am I doing? Get a refresher on how to up your rank and collect badges in the Dojo here.