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



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.