Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want to compare Current Month Value vs Previous Month Value. I made a question 2 days ago for a Current Month vs Previous Month Total Tickets : Get how many tickets were generated in the month before the chosen one
I did that. I created a 2 news fields:
Month(Fecha_Crea) as FechaMonth,
Num(Month(Fecha_Crea)) as Num_Fecha,
Now, I have to compare a different field: 'SLA'. To get SLA, I have this expression:
Count({$<Cumplimiento={'CUMPLIÓ'}>} Ticket)/Count(TOTAL Ticket) . It shows me SLA of Current Month
Now, I want to get a SLA of Previous Month. I did this:
Count({< Num_Fecha = { $(=Max(Num_Fecha) - 1)}>+$<Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket)/Count(TOTAL Ticket)
But it doesn't work.
My expression to get a Current Month Total Tickets is :
Count({ < Num_Fecha = { $(=Max(Num_Fecha) - 1)},[Fecha_Crea.autoCalendar.Month] >}Ticket)
I hope u can help me.
Thanks
Sorry
Count({< Num_Fecha = { $(=Max(Num_Fecha) - 1)},Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket) /
Count(TOTAL {< Num_Fecha = { $(=Max(Num_Fecha) - 1)},[Fecha_Crea.autoCalendar.Month]>} Ticket)
Try
Count({< Num_Fecha = { $(=Max(Num_Fecha) - 1)},Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket)/Count(TOTAL Ticket)
It shows me a wrong number 😕
Hi @Frantz Gonzales
You could try something like that:
Count({$<[Cumplimiento]={'CUMPLIO'},[Fecha_crea.autoCalendar.Date]=
{'>=$(=AddMonths(MonthStart(Today()),-2))<=$(=AddMonths(MonthEnd (Today()),-2))'}>}Ticket/Count(TOTAL Ticket)
Mario Centeno
Sorry
Count({< Num_Fecha = { $(=Max(Num_Fecha) - 1)},Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket) /
Count(TOTAL {< Num_Fecha = { $(=Max(Num_Fecha) - 1)},[Fecha_Crea.autoCalendar.Month]>} Ticket)
It works ! Thanks!