Hi, I created a filter with all the months taken from the "SCOPE" field. this contains 12 months back, in the dashboard I can have all the months written in Italian. Now I would like the default t...
See more...
Hi, I created a filter with all the months taken from the "SCOPE" field. this contains 12 months back, in the dashboard I can have all the months written in Italian. Now I would like the default to be the month prior to today. I tried with <default> $ A_data $ </default> <choice value = "$ A_data $"> PREVIOUS_MONTH </choice> but it does not work. I would like it to be selected by Default (if today we are in April, "MARCH-2021" was selected) Tks Bye Antonio ------ source ------- <form hideFilters="true"> <label> Results and Details: Web survey</label> <fieldset submitButton="false"> <input type="dropdown" token="field1"> <label>Mese</label> <fieldForLabel>field1</fieldForLabel> <fieldForValue>AMBITO</fieldForValue> <search> <query>index=aladin * sourcetype=cruscotto_tnps |search ZONA ="Totale" |eval anno=mvindex(split(AMBITO,"-"),1) |eval mese=mvindex(split(AMBITO,"-"),0) | eval mesi=case( mese="Gennaio","01", mese="Febbraio","02", mese="Marzo","03", mese="Aprile","04", mese="Maggio","05", mese="Giugno","06", mese="Luglio","07", mese="Agosto","08", mese="Settembre","09", mese="Ottobre","10", mese="Novembre","11", mese="Dicembre","12", 1=1, "INV") |eval OrdineAmbito = anno.mesi |sort OrdineAmbito | eval A_mese=strftime(relative_time(now(), "-30d@d"),"%m") | eval A_anno=strftime(relative_time(now(), "-30d@d"),"%Y") | eval A_mesi=case( A_mese="01","Gennaio", A_mese="02","Febbraio", A_mese="03","Marzo", A_mese="04","Aprile", A_mese="05","Maggio", A_mese="06","Giugno", A_mese="07","Luglio", A_mese="08","Agosto", A_mese="09","Settembre", A_mese="10","Ottobre", A_mese="11","Novembre", A_mese="12","Dicembre", 1=1, "INV") |eval A_data= A_mesi."-".A_anno |table AMBITO,A_data</query> <earliest>@d</earliest> <latest>now</latest> </search> <default>$A_data$</default> <choice value="$A_data$">MESE_PRECEDENTE</choice> </input> </fieldset> <row> <panel> <html> <div style="height: 2em; display: flex; align-items: center; justify-content: center;color:blue;font-style:bold;font-size:200%"> <B> $field1$</B> </div> </html> </panel> </row> <row> <panel> <html> </html> </panel> </row> <row> <panel> <single> <title>T-PRO</title> <search> <query>index=aladin * sourcetype=cruscotto_tnps |search ZONA ="Totale" |eval anno = strftime(_time,"%Y") | eval mesi=strftime(_time,"%m") | eval mese=case( mesi="01","Gennaio-", mesi="02","Febbraio-", mesi="03","Marzo-", mesi="04","Aprile-", mesi="05","Maggio-", mesi="06","giugno-", mesi="07","Luglio-", mesi="08","Agosto-", mesi="09","Settembre-", mesi="10","Ottobre-", mesi="11","Novembre", mesi="12","Dicembre-", 1=1, "INV") |eval meseanno= mese.anno |where AMBITO = "$field1$" |sort ZONA |fields T_PRO |stats values(T_PRO)</query> <earliest>@d</earliest> <latest>now</latest> </search> <option name="drilldown">none</option> <option name="height">50</option> <option name="rangeColors">["0x006d9c","0x53a051"]</option> <option name="rangeValues">[500]</option> <option name="refresh.display">none</option> <option name="useColors">1</option> </single> </panel>