Previous Period Date Range - Auto Calculation

Reply
Highlighted
Yellow Belt

Previous Period Date Range - Auto Calculation

Hi all,

I don't have a ton of eperience with Beast Mode/ETL, but was hoping to learn a little more from this. I'm looking to compare sessions for a period between two dates, to the previous period, also between two dates. So, for example, if I have an ad campaign that ran from 6/1/19 - 1/31/20, the previous period would be 9/29/18 - 5/31/19. I know I can do this with a "period over period" chart, but that would require me to calculate the previous period myself. Due to the number of dashboards that will utilize this card, I want something that can perform that calculation automatically, just by setting an initial date range. My data is coming from the Google Analytics connector.

Tl;dr: Is there a way to create a card, that when given a certain date range, will automatically caluclate the previous period and show percent change in sessions between the two? My agency has been using Google Data Studio to create a dashboard with this data before, however I'm hoping that by using DOMO I can simplify dashboard creation. I'm attaching an image of the section of our Data Studio dashboard I'm trying to replicate with this card.

If there's any additional information you need from me to assist, don't hesitate to let me know.

Thanks!


Accepted Solutions
Highlighted
Major Red Belt

Re: Previous Period Date Range - Auto Calculation

@RDSco ,

 

You can accomplish this Period calculation using parameterized queries.  Take a look at this video as a foundation.

https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=2&t=63s

 

You can set a date and then use BEAST MODE + CASE statement to calculate the range of dates for 'current_period' and 'prev_period'

 

cc @GrantSmith  thought you'd like to know.


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

NoETL strikes again! Learn how to add parameterized values to your #Domo reports in this accounts receivables use case. ##### CONSULTING SERVICES #### I hav...

All Replies
Highlighted
Major Red Belt

Re: Previous Period Date Range - Auto Calculation

@RDSco ,

 

You can accomplish this Period calculation using parameterized queries.  Take a look at this video as a foundation.

https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=2&t=63s

 

You can set a date and then use BEAST MODE + CASE statement to calculate the range of dates for 'current_period' and 'prev_period'

 

cc @GrantSmith  thought you'd like to know.


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

NoETL strikes again! Learn how to add parameterized values to your #Domo reports in this accounts receivables use case. ##### CONSULTING SERVICES #### I hav...
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.