Skip to content

    • Charting

    Charting

    Schedule Report - Weekly data report every Friday

    Member
    in Charting

    I am trying to schedule a weekly report that would be sent out every Friday morning for data between the previous Friday and Thursday of the current week (7 days/1 week). For example, data range is 3/3/2023-3/9/2023 for this week's report, whereas next week's report would be data range 3/10/2023-3/16/2023.

    Is there a way to set this up in Domo? I'm finding that if it set a data range for the days, the automated report will only send reports for that given period, not for the current set of weeks.

    image.png
    image.png
    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      @zgranperc in your card, set the date range to be the last 7 days

      image.png

      On your scheduled report, set to run every Friday and make sure the time is set to 12:01am, or something very close to the start of the day. This will keep it dynamic and will work as the weeks go by.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Answers

    • Coach

      Filter your card with a beast mode to calculate the prior week's timeframe and then schedule your report based on the filtered card.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      @GrantSmith what is the beast mode for this?

    • Member

      Hello! Can you provide beast mode to use for 1 week range between Friday (last week) to Thursday (this week)?

    • Coach
      Answer ✓

      @zgranperc in your card, set the date range to be the last 7 days

      image.png

      On your scheduled report, set to run every Friday and make sure the time is set to 12:01am, or something very close to the start of the day. This will keep it dynamic and will work as the weeks go by.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Coach

      @zgranperc If your report is only going to be sent out on Fridays, then you can set your card date range to Last 8 Days and use this beast mode to filter out today's data:

      case when DateField = CURRENT_DATE() then ‘Exclude’ else ‘Include’ end

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories