Date range for Group by on charts

Hi

I am trying to put a column chart in a page to show a count of values over time, but the fusion chart i am using requires the group by section to be set to define the date range.  

Is there a way to set the date range dynamically,so I can have a rolling window, or is there a way to return all the results so i can use filters on the display page?

Version 4.2.0

Thanks

Nick