topic Re: Weekly Filter in Discussions

Weekly Filter

JohannesENS — Sun, 11 Jun 2023 11:24:27 GMT

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.

jthi — Fri, 20 May 2022 06:50:04 GMT

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

JohannesENS — Fri, 20 May 2022 06:56:48 GMT

Filter last seven days based on current day.

jthi — Fri, 20 May 2022 07:12:08 GMT

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

JohannesENS — Fri, 20 May 2022 07:23:54 GMT

Thank you. But where to paste this?

jthi — Fri, 20 May 2022 11:21:28 GMT

I still have no idea how you want to use this "filter", so I cannot really provide more information.

I have attached modified version of JMP's sample data table Big Class with dates.

It has date column (generated with formula) and column which should tell if date is in last 7 days (also formula)

There is also table script which will create graph builder to with local data filter

JohannesENS — Fri, 20 May 2022 11:59:30 GMT

Thank you!