Cases By Priority (Per Day)

Dynamics CRM

 

Dynamics CRM is a widely used cloud CRM from Microsoft, focused on Sales, Marketing, and Service (help desk) sectors.

Active cases assigned to the user per day

Query Text

SELECT
    date(inc."createdon") 'Day (Created On)',
    SUM(case when (inc."prioritycode"='Low') then 1 else 0 end) 'Low',
    SUM(case when (inc."prioritycode"='Normal') then 1 else 0 end) 'Normal', 
    SUM(case when (inc."prioritycode"='High') then 1 else 0 end) 'High'
  FROM 
    "incident" inc
  INNER JOIN 
    "owner" AS owner_inc ON inc."ownerid" = owner_inc."ownerid"
  WHERE 
    inc."statecode" = 'Active' AND owner_inc."name" = 'Devart Corp' 
  GROUP BY 
    date(inc."createdon")
  

Open Query