2 Replies Latest reply on Apr 11, 2013 10:37 AM by Mark Anderson

    How can I visualize two line graphs based on two different date fields in one chart?

    Fabian Binz-Scharf

      Hi,

       

      I'm trying to create a line graph with two lines - one line showing # of service desk tickets created by month (based on create date), the other showing # of completed and resolved service desk tickets by month (based on last activity date). I would need to apply different filters (for ticket status) for both KPIs, as well as I would need the one line displayed based on create date, the other one based on last activity date.

       

      Sample data:

       

      Ticket# | Date Created | Last Activity Date | Status

      0001 | 01/01/2012 | 02/01/2012 | Complete

      0002 | 01/10/2012 | 03/05/2012 | Work in Progress

      0003 | 02/04/2012 | 05/05/2012 | Complete

       

      Ideally I would like to create a graph that shows me a line for created tickets (0001,0002 in Jan, 0003 in Feb) and a line for completed tickets (0001 in Feb, 0003 in May).

       

      I hope that makes sense.

       

      Thanks,

      Fabian