In a dashboard, I have a filter with week numbers which applies to graphs. H
How to do in the script to have a selection of weeks which is updated from the last 3 weeks from today's date ans would be automatic?
Go to Solution
If your column's name is Date, and your reference to the data table is dt....this code will select the rows that fall within the last 3 weeks from today
dt << select where( :Date >= today() - in weeks(3) );
View solution in original post
There are no labels assigned to this post.