Okey ,thank you ... View more

There isn't another solution? ... View more

@niketn my problem is that i don't have the acces to JS.So i can't use "highchart_data_label_percent" ... View more

| streamstats count as row | eval sno =printf("%03d",row) | eval q_commentaireSupplementaire= "Comm ".sno.": ".q_commentaireSupplementaire | stats VALUES(q_commentaireSupplementaire) AS Commentaire BY qa_noteSatisfaction | sort qa_noteSatisfaction desc | rename qa_noteSatisfaction AS Note_Satisfaction ... View more

@niketnilay Error in 'eval' command: The 'printf' function is unsupported or undefined. ... View more

i add the count ,and then the counter ,i still have a prolem with sorting Comm 11:... Comm 1:... Comm 15:... I used aldo sort desc and asc ,but doesnt work too ... View more

This is my query `|loadjob savedsearch="a468413:ied:job_mois_encours" |eval date = strftime(_time,"%Y-%m-%d") | eval earliest_time_relative=relative_time(now(),"-0mon@mon") | eval earliest_time = strftime(earliest_time_relative,"%Y-%m-%d") | eval latest_time_relative=relative_time(now(),"-0d@d") | eval latest_time = strftime(latest_time_relative,"%Y-%m-%d") | where date == "-0mon@mon" OR (_time >= earliest_time_relative AND _time<=latest_time_relative) ` I'im using loadjob ! where can i put the earliest and the latest? Or if there is just an edit in my query it's will be better for my code because i'm using this method for five dashboards ... View more

|eval date = strftime(_time,"%Y-%m-%d") | eval earliest_time_relative=relative_time(now(),"-0mon@mon") | eval earliest_time = strftime(earliest_time_relative,"%Y-%m-%d") | eval latest_time_relative=relative_time(now(),"-0d@d") | eval latest_time = strftime(latest_time_relative,"%Y-%m-%d") | where date == "-0mon@mon" OR (_time >= earliest_time_relative AND _time<=latest_time_relative) ... View more

i want the first day of month as first day ... View more

It's work,thank you 🙂 ... View more

can I write the formula instead of the values? ... View more

No result found ... View more

Hello , I did not understand your answer,can you explain pls my error . Thank you 🙂 ... View more

okey as you want,for me i did not accept your answer because is not really what i want,with your solution i pass from 3min30sec to 3min 10sec I'm searshing a solution to load my dashboard on 2min. We are here to help each other,and you are here to collect votes ... View more

@kmaron <input type="dropdown" token="time_token" searchWhenChanged="true"> <label>Choisir Période</label> <default>-1d@d</default> <choice value="@d">Aujourd'hui</choice> <choice value="-1d@d">Hier</choice> <choice value="-2d@d">Avant Hier</choice> <choice value="-0w@w">Semaine en cours</choice> <choice value="-1w@w">Semaine précédente</choice> <choice value="-0mon@mon">Mois en cours</choice> <choice value="-1mon@mon">Mois précédent</choice> <choice value="-0y@y">Année en cours</choice> <choice>Semaine</choice> <change> <condition label="Semaine"> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="token_span">$depends_token_11$</set> <set token="show_Data_Labels_token">all</set> <set token="depends_token_11">true</set> <unset token="depends_token_12">true</unset> </condition> <condition label="Aujourd'hui"> <set token="earliest1_token">true</set> <set token="earliest_token">@d</set> <set token="latest_token">-0d@</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <set token="depends_token_10">true</set> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span10$</set> <unset token="x1_x1">true</unset> <unset token="x2_x2">true</unset> <set token="x3_x3">true</set> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!-- <set token="loadjob_token_job">job_mois_encours</set> <set token="loadjob_token_job">job_mois_encours_backup</set>--> <set token="saved">"XX:ied:job_tchat_today"</set> <set token="savedd">"XX:ied:job_tchat_today"</set> </condition> <condition label="Hier"> <set token="earliest1_token">true</set> <set token="earliest_token">-1d@d</set> <set token="latest_token">-0d@d</set> <set token="time_token">true</set> <set token="depends_token_1">true</set> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span1$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!-- <set token="loadjob_token_job">job_mois_encours</set> <set token="loadjob_token_job">job_mois_encours_backup</set>--> <set token="saved">"XX:ied:job_mois_encours"</set> <set token="savedd">"XX:ied:job_mois_encours"</set> </condition> <condition label="Avant Hier"> <set token="earliest1_token">$value$</set> <set token="earliest_token">-2d@d</set> <set token="latest_token">-1d@d</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <set token="depends_token_6">true</set> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span6$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!-- <set token="loadjob_token_job">job_mois_encours</set> <set token="loadjob_token_job">job_mois_encours_backup</set>--> <set token="saved">"XX:ied:job_mois_encours"</set> <set token="savedd">"XX:ied:job_mois_encours"</set> </condition> <condition label="Semaine en cours"> <set token="earliest1_token">true</set> <set token="earliest_token">-0w@w1</set> <set token="latest_token">-0d@d</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <set token="depends_token_2">true</set> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span2$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!-- <set token="loadjob_token_job">job_mois_encours</set> <set token="loadjob_token_job">job_mois_encours_backup</set>--> <set token="saved">"XX:ied:job_mois_encours"</set> <set token="savedd">"XX:ied:job_mois_encours"</set> </condition> <condition label="Semaine précédente"> <set token="earliest1_token">-1w@w1</set> <set token="earliest_token">-1w@w1</set> <set token="latest_token">@w7</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <set token="depends_token_7">true</set> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span7$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!-- <set token="loadjob_token_job">job_mois_encours</set> <set token="loadjob_token_job">job_mois_encours_backup</set>--> <set token="saved">"XX:ied:job_mois_encours"</set> <set token="savedd">"XX:ied:job_mois_encours"</set> </condition> <condition label="Mois en cours"> <set token="earliest1_token">true</set> <set token="earliest_token">$value$</set> <set token="latest_token">-0d@d</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <set token="depends_token_3">true</set> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span3$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!-- <set token="loadjob_token_job">job_mois_encours</set> <set token="loadjob_token_job">job_mois_encours_backup</set>--> <set token="saved">"XX:ied:job_mois_encours"</set> <set token="savedd">"XX:ied:job_mois_encours"</set> </condition> <condition label="Mois précédent"> <set token="earliest1_token">$value$</set> <set token="earliest_token">-1mon@mon</set> <set token="latest_token">-0mon@mon</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <set token="depends_token_8">true</set> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span8$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <!--<set token="loadjob_token_job">job_mois_fevrier_2018</set>--> <set token="saved">"XX:ied:job_fevrier_2018_backup"</set> <set token="savedd">"XX:ied:job_fevrier_2018_backup"</set> </condition> <condition label="Année en cours"> <set token="earliest1_token">true</set> <set token="earliest_token">-2mon@mon</set> <set token="latest_token">-0d@d</set> <set token="time_token">true</set> <unset token="depends_token">true</unset> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <set token="depends_token_4">true</set> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span4$</set> <unset token="x1_x1">true</unset> <set token="x2_x2">true</set> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <set token="savedd">"XX:ied:job_year"</set> </condition> <!-- <condition label="Année précédente"> <set token="earliest1_token">$value$</set> <set token="earliest_token">true</set> <set token="latest_token">-0y@y</set> <set token="time_token">true</set> <unset token="depends_token">true</unset> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <set token="depends_token_9">true</set> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span9$</set> </condition>--> <condition label="*"> <set token="earliest1_token">true</set> <set token="earliest_token">true</set> <set token="latest_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <set token="depends_token_5">true</set> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="show_Data_Labels_token">all</set> <set token="token_span">$token_span5$</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <unset token="depends_token_11">true</unset> <unset token="depends_token_12">true</unset> <set token="saved">"XX:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> </change> <fieldForLabel>time</fieldForLabel> <fieldForValue>time</fieldForValue> </input> <input type="dropdown" token="token_span11" depends="$depends_token_11$" searchWhenChanged="true"> <label>Choisir semaine</label> <choice value="w1">Semaine 1 </choice> <choice value="w2">Semaine 2 </choice> <choice value="w3">Semaine 3 </choice> <choice value="w4">Semaine 4 </choice> <choice value="w5">Semaine 5 </choice> <choice value="w6">Semaine 6 </choice> <choice value="w7">Semaine 7 </choice> <choice value="w8">Semaine 8 </choice> <choice value="w9">Semaine 9 </choice> <choice value="w10">Semaine 10 </choice> <choice value="w11">Semaine 11 </choice> <choice value="w12">Semaine 12 </choice> <choice value="w13">Semaine 13 </choice> <change> <condition label="Semaine 1"> <set token="earliest1_token">true</set> <set token="earliest_token">@y</set> <set token="latest_token">@y+1w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 2"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+1w</set> <set token="latest_token">@y+2w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="a468413:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"XX:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 3"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+2w</set> <set token="latest_token">@y+3w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 4"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+3w</set> <set token="latest_token">@y+4w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 5"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+4w</set> <set token="latest_token">@y+5w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="a468413:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"XX:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 6"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+5w</set> <set token="latest_token">@y+6w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 7"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+6w</set> <set token="latest_token">@y+7w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 8"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+7w</set> <set token="latest_token">@y+8w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 9"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+8w</set> <set token="latest_token">@y+9w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 10"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+9</set> <set token="latest_token">@y+10w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 11"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+10w</set> <set token="latest_token">@y+11w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 12"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+11w</set> <set token="latest_token">@y+12w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> <condition label="Semaine 13"> <set token="earliest1_token">true</set> <set token="earliest_token">@y+12w</set> <set token="latest_token">@y+13w</set> <set token="time_token">true</set> <unset token="depends_token_1">true</unset> <unset token="depends_token_2">true</unset> <unset token="depends_token_3">true</unset> <unset token="depends_token_4">true</unset> <unset token="depends_token_5">true</unset> <unset token="depends_token_6">true</unset> <unset token="depends_token_7">true</unset> <unset token="depends_token_8">true</unset> <unset token="depends_token_9">true</unset> <unset token="depends_token_10">true</unset> <set token="depends_token_11">true</set> <set token="depends_token_12">true</set> <set token="token_span">$depends_token_12$</set> <set token="show_Data_Labels_token">all</set> <set token="x1_x1">true</set> <unset token="x2_x2">true</unset> <unset token="x3_x3">true</unset> <set token="saved">"a468413:ied:job_mois_encours" |append[loadjob savedsearch="a468413:ied:job_fevrier_2018_backup"]</set> <set token="savedd">"XX:ied:job_mois_encours" |append[loadjob savedsearch="XX:ied:job_fevrier_2018_backup"]</set> </condition> </change> </input> <input type="radio" token="token_span1" depends="$depends_token_1$"> <label>Choisir échelle</label> <choice value="5m">5 minutes</choice> <choice value="15m">15 minutes</choice> <choice value="1h">1 heure</choice> <change> <set token="token_span">$value$</set> </change> <default>1h</default> <initialValue>1h</initialValue> </input> <input type="radio" token="token_span2" depends="$depends_token_2$"> <label>Choisir échelle</label> <choice value="1H">1 heure</choice> <choice value="1d">1 jour</choice> <change> <set token="token_span">$value$</set> </change> <default>1d</default> <initialValue>1d</initialValue> </input> <input type="radio" token="token_span10" depends="$depends_token_10$"> <label>Choisir échelle</label> <choice value="5m">5 minutes</choice> <choice value="15m">15 minutes</choice> <choice value="1h">1 heure</choice> <change> <set token="token_span">$value$</set> </change> <default>1h</default> <initialValue>1h</initialValue> </input> <input type="radio" token="token_span12" depends="$depends_token_12$"> <label>Choisir échelle</label> <choice value="1H">1 heure</choice> <choice value="1d">1 jour</choice> <change> <set token="token_span">$value$</set> </change> <default>1d</default> <initialValue>1d</initialValue> </input> <input type="radio" token="token_span7" depends="$depends_token_7$"> <label>Choisir échelle</label> <choice value="1H">1 heure</choice> <choice value="1d">1 jour</choice> <change> <set token="token_span">$value$</set> </change> <default>1d</default> <initialValue>1d</initialValue> </input> <input type="radio" token="token_span3" depends="$depends_token_3$"> <label>Choisir échelle</label> <choice value="1d">1 jour</choice> <choice value="1w">1 semaine</choice> <change> <set token="token_span">$value$</set> </change> <default>1w</default> <initialValue>1w</initialValue> </input> <input type="radio" token="token_span8" depends="$depends_token_8$"> <label>Choisir échelle</label> <choice value="1d">1 jour</choice> <choice value="1w">1 semaine</choice> <change> <set token="token_span">$value$</set> </change> <default>1w</default> <initialValue>1w</initialValue> </input> <input type="radio" token="token_span4" depends="$depends_token_4$"> <label>Choisir échelle</label> <choice value="1d">1 jour</choice> <!--<choice value="1w">1 semaine</choice>--> <choice value="1mon">1 mois</choice> <change> <set token="token_span">$value$</set> </change> <default>1mon</default> <initialValue>1mon</initialValue> </input> <input type="radio" token="token_span9" depends="$depends_token_9$"> <label>Choisir échelle</label> <choice value="1d">1 jour</choice> <choice value="1w">1 semaine</choice> <choice value="1mon">1 mois</choice> <change> <set token="token_span">$value$</set> </change> <default>1mon</default> <initialValue>1mon</initialValue> </input> <input type="radio" token="token_span5" depends="$depends_token_5$"> <label>Choisir échelle</label> <choice value="5m">5 minutes</choice> <choice value="15m">15 minutes</choice> <choice value="1h">1 heure</choice> <change> <set token="token_span">$value$</set> </change> <default>1h</default> <initialValue>1h</initialValue> </input> <input type="radio" token="token_span6" depends="$depends_token_6$"> <label>Choisir échelle</label> <choice value="5m">5 minutes</choice> <choice value="15m">15 minutes</choice> <choice value="1h">1 heure</choice> <change> <set token="token_span">$value$</set> </change> <default>1h</default> <initialValue>1h</initialValue> </input> <input type="dropdown" token="media_token" searchWhenChanged="true"> <label>Choisir Media</label> <choice value="*">ALL</choice> <default>*</default> <prefix>media="</prefix> <suffix>"</suffix> <fieldForLabel>media</fieldForLabel> <fieldForValue>media</fieldForValue> <search> <query> |loadjob savedsearch=$savedd$ |eval date = strftime(_time,"%Y-%m-%d") | eval earliest_time_relative=relative_time(now(),"$earliest_token$") | eval earliest_time = strftime(earliest_time_relative,"%Y-%m-%d") | eval latest_time_relative=relative_time(now(),"$latest_token$") | eval latest_time = strftime(latest_time_relative,"%Y-%m-%d") | where date == "$time_token$" OR (_time &gt;= earliest_time_relative AND _time&lt;=latest_time_relative) | dedup media </query> </search> </input> <row> <panel> <chart depends="$x1_x1$"> <title>1) Affichage du Tchat dans le Sticky (si CC dispo)</title> <search> <query>| loadjob savedsearch=$saved$ | search $media_token$ $chatOrigin_token$ |eval date = strftime(_time,"%Y-%m-%d") | eval earliest_time_relative=relative_time(now(),"$earliest_token$") | eval earliest_time = strftime(earliest_time_relative,"%Y-%m-%d") | eval latest_time_relative=relative_time(now(),"$latest_token$") | eval latest_time = strftime(latest_time_relative,"%Y-%m-%d") | where date == "$time_token$" OR (_time &gt;= earliest_time_relative AND _time&lt;=latest_time_relative) |timechart span=$token_span$ count(eval(step="AVAILABILITY AFFICHAGE" AND chatAvailability_lo=0)) AS Affichage_KO,count(eval(step="AVAILABILITY AFFICHAGE" AND chatAvailability_lo=1)) AS Affichage_OK</query> <earliest>$earliest$</earliest> <latest>$latest$</latest> </search> <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option> <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option> <option name="charting.axisTitleX.text">Temps</option> <option name="charting.chart">column</option> <option name="charting.chart.stackMode">default</option> <option name="charting.drilldown">all</option> <option name="charting.layout.splitSeries">0</option> </chart> </panel> </row> </form> ... View more

I already upvote the answer 😉 ... View more

when i used "field" ,my dashboard is faster but i have the results of the 15 last days ,and not of all the week ... View more

i changed my request ,now i use : index="YOUR_INDEX_NAME" feature="chat" | stats values(MESSAGE) AS MESSAGE by _time It's accelerat my dashboard by 30sec ... View more

i changed table b fields to accelerate the research,the probem is ,when i use table it's return all the data of the month,but when i use field it's return just the last 15 days ... View more