Explore recipe: Creating weekly date buckets

Return to top

13 Comments

  • Shehryar Khaliq Lodhi

    Is this possible for two weeks?

     

    like from 29 November to 5th December and from 6th December to 12th December on the report ?

    0
  • Elaine
    Zendesk Customer Care
    Hi Shehryar,
     
    If you only want to see certain weekly date buckets (in your case, for two weeks only) in your query, you can click into the weekly date bucket attribute that you just created and filter out the two weeks like in the screenshot below:
     

     
    Once you applied the filter into the attribute, you should only see the two weeks bucket in your query instead of seeing a long list of weekly buckets.
     

     
    Hope this helps! Stay safe!
    0
  • Taguhi Martirosian

    Hi. Please support how to select "Tickets created" in metrics when there is no such option. I need you assistance. Thank you

    1
  • Cheeny Aban
    Zendesk Customer Care
    Hi Taguhi

    Are you trying to create a query and the metrics is not showing even after searching for the same in Metrics? 
    0
  • Adam Goodell

    Hi Taguhi,

    I found the metric "Tickets created" in another dataset, Support - Updates. Not Support - Tickets as shown in the recipe above.

    0
  • Naielly Carravieri

    Olá,

    No meu caso a personalização das semanas para os dias da semana deu certo porém, a ordem cronológica veio ordenada pelas primeiras semanas do ano. Alguém saberia me dizer o porque ou como eu poderia reclassificar essa ordem sem ser manualmente?

    A ordem ficou assim:

    Usei a mesma fórmula dada anteriormente:

    0
  • Gabriel
    Zendesk Customer Care
    Olá Naielly,

    Espero que esteja tudo bem! Você pode tentar organizar os valores através das ferramentas de Organização de valores por grupos e conjuntos.

    Espero que isso ajude!
    0
  • Mike

    Is it possible to aggregate the EOY duplicate weeks? Or some workaround to resolve this?

    0
  • Viktor Osetrov
    Zendesk Customer Care
    Hello Mike,

    Thanks for your screenshot. It happens because you are mixing default and custom attributes in the raw.
    As a solution, we would like to recommend using default and custom attributes separately:
    1) Custom. Creating standard calculated attributes which will include your custom data per week from a specific report year;
    2) Default. You can create a waterfall using default ticket attributes

    Hope it helps
     
    0
  • Wyatt

    When swapping out [DATE(Date)], as per the instructions, I receive the following error: 
    "Can't use (number) in this function. Use (timestamp)."
    I wasn't able to locate this error in the Troubleshooting Errors doc. 

    Below is the formula I am attempting to use:

    DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Week of year]), "YYYY-MM-dd")
    0
  • Alex Zheng
    Zendesk Customer Care
    Hey Wyatt,

    I believe this error is due to the START_OF_WEEK_MONDAY function, you need to input a date rather than the week of year function. So the formula should look like:

    DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Date]), "YYYY-MM-dd")
     
    OR

    DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Timestamp]), "YYYY-MM-dd")

    Let me know if you have any further questions.
    0
  • Efrat Barak Zadok

    Is there a way to show last 4 weeks from current date?

    0
  • Elaine
    Zendesk Customer Care
    Hi Efrat,
     
    You may add a date filter that's similar attribute you've used into the calculated attribute you created and choose the advance option to select the date range from today to 4 weeks in the past. 🙂 
     

    0

Please sign in to leave a comment.

Powered by Zendesk