A year or so ago I created a video to demonstrate some techniques for filtering collections and charts using pure data editor logic. The video is available on Youtube:
Somebody recently asked if it would be possible to access the App that was used in the above video, so I have now made it available as a copyable private template.
One issue: when I set the date range from 24 Feb to 25 Feb, it only shows sales from 24 Feb, and completely ignores 25 Feb. I tried adjusting the column filter (filter/ifMatchDateRange) in the sales table by changing it to use “on or before” and “on or after”, but it broke the system when I did that.