You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Count incidents when a date_group and count(*) is used

edited Sep 20, 2017 6:20PM in Reporting & Analytics for B2C Service 5 comments

Content

I have a report with 3 columns

  1. DATE - date_group(incidents.created,'YYYY-MM-DD')
  2. SOURCE - incidents.source_lvl2
  3. COUNT - count(*)

So this shows how many incidents of each source type were raised in a day. What I am looking for is a 4th column to show a total number of incidents raised in that day - so this number will be all of the 3rd column added together for a day

How would I do this? I need it sorting like this and not in a rollup as I will be using ConnectPHP to expose it to a web page.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!