Hi @gcusello , Thank you for your help. I was able to get to a solution on this way: I created a dataset with the months and the range dates that I needed: Then using the dropdown created with the months that can be selected by the user I added a sub search to each panel on the dashboard using that as a filter (based on the token from the dropdown). [search index=index_used | head 1 | fillnull value="" | eval month="$month_search$" | eval year=strftime(_time,"%Y") | lookup Months.csv Month as month OUTPUT Start_Date as RR_Start_Date, End_Date as RR_End_Date | eval latest=RR_End_Date.year | eval year=if(month="January", year - 1, year) | eval earliest=RR_Start_Date.year | eval earliest=strptime(earliest,"%m/%d/%Y") | eval latest=strptime(latest,"%m/%d/%Y") | table earliest, latest | format "" "" "" "" "" ""] Regarding your question: Then I don't understand how you manage the missing periods, e.g. from 06/01/2023 and 14/01/2023 -> On that period we don't have data that should be used on the report. Thank you!
... View more