Insights date dimensions

Have more questions? Submit a request

17 Comments

  • Ronald Devine
    Comment actions Permalink

    Can this be updated?  There are a number of date attributes not list here.

    1
  • Christopher C.
    Comment actions Permalink

    Hello,

    I don't have Date (Event) in my Zendesk. How do I get it added?

    0
  • Graeme Carmichael
    Comment actions Permalink

    Christopher

    Can you just check after creating a report, under the HOW option, it should be listed like this:

    0
  • Conza
    Comment actions Permalink

    Hi,

    I am trying to do create a report - specifically to show data for tickets created per week , FROM or AFTER a specific week. 

    They all seem to relate to days previous, weeks past, etc. but you can't do it so it scraps everything from previous weeks, and then just starts going onwards from a date.

    Basically - we had new channel setup for awhile, but only this week - started using and want to show that data only.. 

    Any help, greatly appreciated.

     

    0
  • Graeme Carmichael
    Comment actions Permalink

    Conza

    So you will know a specific date from when you want to start reporting on tickets. Create a new custom metric:

    Here I only want to see tickets created on or after 1 August 2018. Be sure to use the element selector from the right hand pane to select  # Tickets, Date (Ticket Created) and the starting date.

    Include the metric in your report numeric filter:

     

    1
  • Conza
    Comment actions Permalink

    Legend, thank you! Will try that out.

    Very surprised that isn't an actual feature in the options.

    0
  • Allison Crane
    Comment actions Permalink

    I'm trying to pull a report that compares monthtly each year. So how may tickets were opened and solved last year in October comparerd to how many tickets this year in October were created and solved?

    Any help would be greatly appreciated.

     

    0
  • Graeme Carmichael
    Comment actions Permalink

    Allison

    You can make a table with the built in metrics.

    WHAT

    • # Tickets Created
    • # Tickets Solved

    HOW

    • Month (Event)
    • Year (Event)

    FILTER

    • Year (event) is the last 2 year

     



    0
  • Allison Crane
    Comment actions Permalink

    Thank you so much for your quick reply!

     

    Allison

    0
  • Allison Crane
    Comment actions Permalink

    I keep getting an error whe n creating the report.

    Here is how I have it set up.

     



    0
  • Graeme Carmichael
    Comment actions Permalink

    Allison

    You need to have eagle eyes for this.  

    Replace your metric # Sloved tickets with # Tickets solved. 

    The two are not the same and I believe that is causing the error.  

    0
  • Carlos Santos
    Comment actions Permalink

    Hi everyone.

    How about form fields of the "date" type? Do they pass from Zendesk to Gooddata? I have one on our form and I can't find it on the "How" tab.

    Thanks.

     

    0
  • Graeme Carmichael
    Comment actions Permalink

    Carlos

    Yes, date fields are passed to GoodData.

    You will find them in a folder of their own rather than along with the ticket fields.

     

    0
  • Carlos Santos
    Comment actions Permalink

    Oops! Hadn't noticed it :-)

    Thank you so much, Graeme!

    0
  • Lohith S
    Comment actions Permalink

    I don't find the Date (Event) like Month (Event), Week (Event) in Explore, all the date attributes are associated with Tickets, Users, Org etc categories. However this is present in Insights. 

    0
  • Dylan Tragjasi
    Comment actions Permalink

    Hi Lohith,

    In order to utilize the equivalent attributes to Date (Event), Month (Event), etc. within Explore, you'll need to make sure you're creating a query based on the Ticket Updates dataset.

    You can then put together queries using the "Update" attributes, e.g. Update - Date or Update - Month - e.g:



    Hope this helps!
    - Dylan  

    0
  • Lohith S
    Comment actions Permalink

    Hi Dylan,

    I don't see the Update group attribute at all.

    0

Please sign in to leave a comment.

Powered by Zendesk