1 Reply Latest reply on Mar 11, 2013 10:04 AM by Jamie Cannon

    Creating a Chart from a query with a date grouping shows all records based on time?

    Apprentice

      I have created a few queries that I would like to publish as dashboard charts/graphs, but all of these are time based.  The queries run as expected and I have used groups on RaiseDate (Monthly) as well as Inciden Source (i.e Phone Call, Email, Voicemail, In Person etc) with the hope of being able to see all incidents logged over those periods.  In the query results view this shows fine (in console), however, in a dashobard chart all the date related groups include the time, so all are showing as their own entry.

       

      Is there a way to get these to show as they were selected in the date grouping options (i.e. daily, weekly, monthly)

       

      Cheers