Untitled

unknown
plain_text
a year ago
1.6 kB
Indexable
Never
KPI Calendario = 
IF([Issue status]  <> "CANCELADO" && [Issue status]  <>  "CLOSED" && [Issue status]  <> "DESPRIORIZADO PO" && [Issue status]  <> "OPEN" && [Issue status]  <> "CANCELLED" && [Issue status]  <> "TO-DO" && [Issue status]  <> "ON HOLD" && [Issue status]  <> "BACKLOG" && [Issue status]  <>"RESOLVED" && [Issue status]  <> "DONE"  && [Issue status]  <> "POR HACER" && NOT(ISBLANK([Issue status])) && (TODAY() > [Issue ES-Committed End Date] || [Issue End date] > [Issue ES-Committed End Date]) , 
   2,
   
IF([Issue status]  <> "CANCELADO" && [Issue status]  <>  "CLOSED" && [Issue status]  <> "DESPRIORIZADO PO" && [Issue status]  <> "OPEN" && [Issue status]  <> "CANCELLED" && [Issue status]  <> "TO-DO" && [Issue status]  <> "ON HOLD" && [Issue status]  <> "BACKLOG" && [Issue status]  <>"RESOLVED" && [Issue status]  <> "DONE"  && [Issue status]  <> "POR HACER" && NOT(ISBLANK([Issue status])) && (NOT(ISBLANK(BJ[Issue Colaboracion Cross Solicitada]) && ISBLANK(BJ[Issue Colaboracion Solicitada])) && [Alerta.1] = 1 && [Colaboración] = "No"),1,

   IF([Issue status]  = "CANCELADO" || [Issue status]  =  "CLOSED" || [Issue status]  = "DESPRIORIZADO PO" || [Issue status] = "OPEN" || [Issue status]  = "CANCELLED" || [Issue status] = "TO-DO" || [Issue status]  = "ON HOLD" || [Issue status] = "BACKLOG" || [Issue status]  = "RESOLVED" || [Issue status]  = "DONE" || [Issue status] ="POR HACER" || ISBLANK([Issue status]),3,0)))

//KPI Calendario Color = switch([KPI Calendario], 0, "Verde", 1, "Amarillo", 2, "Rojo", 3, "Otro estado")