How to get a 3month or quarterly filter in the dashboard.

Hi,

I am still not sure if I get you right. Maybe you can explain it in more detail or share some screenshots.

But you can try the following and sure maybe there is a much easier solution for your request. But here is how I would solve it:

Create a drop down that will be used as filter with a similar logic like this:

'0' || TO_STRING(QUARTER(BSEG.BUDAT)) || ' - ' || TO_STRING(YEAR(BSEG.BUDAT))

Use Load Entries and write your selection into a variable.

e.g you select 02-2021 and this is now the value shown within your selected variable.

*You can also think about using two different drop downs. One for selecting a quarter and another one to select the year.

By the way select "Component is not filtered with selections" on your drop down(s)

Add another two variables in order to get the quarter of your date field and the year of your date field. e.g:

variable quarter:

'0' || TO_STRING(QUARTER(BSEG.BUDAT))

variable year:

TO_STRING(YEAR(BSEG.BUDAT))

Now add the following filter to your sheet or component filter:

FILTER <%=quarter%> = SUBSTRING('<%=filter_variable%>', 0,2);

FILTER <%=year%> = SUBSTRING('<%=filter_variable%>', 5,4);

BR

Dennis