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)