Explore recipe: Using a Sunday to Saturday week attribute

Return to top

4 Comments

  • Jess Hartley

    Could I use this to filter for the previous week with the week starting on Sunday? For tickets updated the previous week, Sun-Sat for a report that I would run each Monday morning. If so, how or is there an easier way to filter this specific way?

    0
  • Brandon Tidd (729)
    Community Moderator
    The Humblident Award - 2021

    Hi Jess Hartley -

    If you're just looking to Filter data based on the previous week, starting on Sunday - we can actually use the default "Ticket Created - Date" filter.  In this case, we'd navigate over to "Advanced" and select "7 Days in the Past" to "2 Days in the Past."  If run on Monday, this would give you Sun - Sat.  If you ran it on Tuesday, you'd have to 'back date' it to 8 Days and 3 Days, respectively.  Hope this helps!

    Brandon Tidd
    729 Solutions

    0
  • Nicole

    What may be the best way to have it run for monthly values, from the 1st of the month until the last day of the month (which varies)? Then the following Monday after the last day of the month it will be sent in a scheduled dashboard report. 

    0
  • Dane
    Zendesk Engineering
    Hi Tanya, 
     
    There are two ways you can create this report. Please check the screenshot for reference. I have used the same attributes but placed it differently on rows, columns and filter sections.
     

     
    The screenshot above shows all tickets created on the same days of the month.
     

     
    On the other hand, this one will include all the days of the month and it will give you the ability to select specific days. You can modify it further depending on your preference.
     
    Now, for Scheduling Dashboards Deliveries, it can be sent on a monthly basis. You can also select the numerical value of the day of the month. 
     

    0

Please sign in to leave a comment.

Powered by Zendesk