Forums

Expand all | Collapse all

How to show Tickets by Customer dated

  • 1.  How to show Tickets by Customer dated

    Posted 30 days ago
    Has anyone created a widget to show customer tickets by date? 

    This to cross reference a customer internal - Customer (start date 

    The plan here is to show what tickets the customer opened within two weeks of their start date.

    #Dashboards/Widgets

    ------------------------------
    Gerald Balluff
    Lyft
    ------------------------------


  • 2.  RE: How to show Tickets by Customer dated

    Expert
    Posted 30 days ago
    I think that would be a fairly simple. 

    You'd just have a related clause in your query to reference the customer and grab the start date and check it's greater or equal to the current date -2 weeks. 

    e.g. this shows all tickets where the customer start date (created date in my case) was in the past 2 weeks:







    ------------------------------
    Graham Moore
    ------------------------------