[ARCHIVED] Number of new tickets created between certain Times | Community
Skip to main content

[ARCHIVED] Number of new tickets created between certain Times

  • July 13, 2021
  • 1 reply
  • 0 views
R

Hi

I am trying to get some data to show the number of NEW tickets created between certain time parameters. In my use case I am looking for :

The number of New tickets created between 8pm and 8am each day. 

The visual only needs to show the last 7 days.

Any ideas or support will be welcome.

    1 reply

    C
    • Chandra13
    • July 13, 2021

    This help article should be a pretty helpful resource for you. You'll just need to adjust the formula for the custom attribute the article highlights to match the exact hours and days of the week you'd like to filter for.

    For Step 11, you could select this newly created attribute and apply it as a filter for your Explore query instead so you only see the number of Tickets created during 8am and 8pm. 

    Feel free to comment on the post if you need more help!

    Terms & ConditionsCookie settingsAccessibility statement