AnsweredAssumed Answered

call truncate/ Brought forward the open calls

Question asked by S.Vigneshkumar on Mar 2, 2015
Latest reply on Mar 10, 2015 by Brian_Mathato

Hi

 

We tried to get the JAN month unresolved calls+ FEB month total calls and we are unable to get when the JAN month unresolved calls was resolved.
Below is the query;
=Count([Ref Num]Where([Priority Symbol] = "1" And (MonthNumberOfYear([Open Date])=2)))+[Unresolved 1]


Unresolved 1 measure Variable.

=Count([Ref Num]Where( [Priority Symbol] = "1" And [Status] <>"RE" And (MonthNumberOfYear([Open Date])=1)))

 

Please help/guide us to achieve the same.

 

Regards,

Vignesh

Outcomes