First I want to say thanks for your previous help again .
Now I have one more issue remain .Below is the expected output when user select Call Type as 'PROBLEM' and Support Group as ADM.
But here it’s coming like below and you can see the Y axis has very different value from above
Below is the code what I have written as script form PROBLEM (similarly for Request and Project)
Ticket_ID as Ticket_ID_proj,
floor(Create_Date) as [Generic Date],
WeekName(date(num#([Create_Date]),'M/DD/YYYY'),0,-1) as [Generic Week],
MonthsName(1,date(num#([Create_Date]),'M/DD/YYYY')) as [Generic Month],
'Created Date' as DateType
where Call_Type = 'PROBLEM';
And here is the expression which I am using to display PROBLEM Graph
Similarly Graph is not showing the correct values when selecting one or two call type.
Please help. Thanks in Advance