488718_en-US

liliconcom

Weekly Filter

Hello everybody,

 

i do have a column in the following format: dd/mm/yyyy hh:mm:ss

 

I want do add a filter which shows only the last seven days.

Is there a possibility to do this? Unfortunately, I have no experience in scripting/JSL.

 

Thanks in advance.

AnalyticsData TableGraphicsScriptingRe: Weekly Filter

Filter with week number (and year) or last seven days? And if last seven days which date should it be based on?

Re: Weekly Filter

Filter last seven days based on current day.

Re: Weekly Filter

Not sure where the filter will be, but you can get the date for example with something like this:

Names Default To Here(1);

new_date = Today() - In Days(7);
new_date = new_date - Time Of Day(new_date);
As Date(new_date); //13May2022

Re: Weekly Filter

Thank you. But where to paste this?