Intelligent Handling Dates in Data

If you have columns in your source report that are dates, Scoop works hard to help you leverage them. When analyzing your data, Scoop will give you the opportunity to change which date it is using for analysis. Clicking on the three dot menu next to a report metric, for example, gives you a drop-down that allows you to change that.

Added date columns in snapshot reports

Scoop adds some powerful logic for other dates in snapshot datasets. In essence, Scoop keeps track of all the unique IDs it has ever seen across all snapshots and the latest values for each. This way, for example, if you wanted to analyze sales opportunities by created date, Scoop will do that, but it will include the latest instance of every opportunity it has ever seen, not just the ones in the latest version of the source report. This provides a nice mechanism for accumulating data over time and giving you a complete picture without having to load your entire dataset every day.