Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
count({<PRIORITY = {'Low'}>,<TEMPOTRASCORSO = {'>=0 AND <=24'}>} [TICKET])
count({<PRIORITY = {'Low'}>,<TEMPOTRASCORSO = {'>=25 AND <=50'}>} [TICKET])
count({<PRIORITY = {'Low'}>,<TEMPOTRASCORSO = {'>=51 AND <=100'}>} [TICKET])
EXAMPLE
TABLE
PRIORITY TEMPOTRASCORSO
low 34
low 1
low 292
normal 23
normal 2
urgent 3
urgent 40
urgent 455
Normally I count(PRIORITY) but this time I need to count how many TICKET fall in the range indicated TEMPO TRASCORSO having priority Low or normal or urgent
Any suggest?
Hi,
the result is 0.
no work
Does [PROGRESSIVO SEGNALAZIONI] repeat and can possible have multiple DELTAs and/or multiple TempoTrascorso?
Use the same expression in Set Analysis or Preferably create a field
in loadScript for TempoTrascorso example
interval(interval#('TempoTrascorso ','d mm:hh:ss'),'h') as Hrs_TempoTrascorso;
for now try below;
count({< [PROGRESSIVO SEGNALAZIONI] = {"=PRIORITY = 'Low' AND (interval(interval#('TempoTrascorso ','d mm:hh:ss'),'h')>=0 AND interval(interval#('TempoTrascorso ','d mm:hh:ss'),'h')<=24)"}>} [PROGRESSIVO SEGNALAZIONI])
After you create a numeric field use
count({< [PROGRESSIVO SEGNALAZIONI] = {"=PRIORITY = 'Low' AND Hrs_TempoTrascorso>=0 AND Hrs_TempoTrascorso<=24)"}>} [PROGRESSIVO SEGNALAZIONI])
Hi
PROGRESSIVO SEGNALAZIONE is a value as a key.
Hi,
in loadscript already exist
DTDELTA AS DELTA,
interval(Interval#([DTDELTA],'D hh:mm'),'h') as TempoTrascorso,
yours ....interval(interval#('TempoTrascorso ','d mm:hh:ss'),'h') as TempoTrascorso1,
and TempoTrascorso contains values converted in hour (0, 1, 2, 3, 35, 96 ....)
But formula
count({< [PROGRESSIVO SEGNALAZIONI] = {"=PRIORITY = 'Low' AND (TempoTrascorso)>=0 AND (TempoTrascorso)<=4"}>} [PROGRESSIVO SEGNALAZIONI])
consider 4 day instead of 4h.
So that my column
'Entro 4 h'
count 1 until 96 and then 0.
instead of count should be 4 until 4 and then 0