Looking to filter chart data by user defined "from" and "to" dates

[Agent5D]

Hi!

I'd like to create a dashboard that displays a chart with all data, and have the option for a user to filter the chart results based on a from and to date.  Something like this: 

https://www.appsheet.com/templates/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=912...

But with dates instead of colors. Is this possible?  Thanks

[graham_howe · Accepted solution]

You just need to convert your statement into something that evaluates as True/False, like this:

AND(
  [Timestamp] >= Chart Date[From Date],
  [Timestamp] <= Chart Date[To Date]
)

This filter will evaluate to True for any rows with a timestamp within the range.