Time series data is used in many of the industries we work with here at Alteryx. In some cases, we start with data that’s been measured by day and find that it’s a little too granular. The obvious solution here is to start rolling up the daily data into larger groups and experimenting with different aggregation levels, but this can quickly become difficult and/or tedious depending on the kind of aggregation you’re trying to do.
With that in mind, I decided to make a tool that would handle a lot of the work for you. The Date Aggregator allows you to take per-day time series data and roll it up into all sorts of different intervals.
People say you can spend upwards of 60% of your time “preparing” your data rather than analyzing it. Alteryx Designer has great, user-friendly tools to try to cut into that estimate, but the tools are purposefully generic so that they can be applied to as many situations as possible. If you find yourself applying the same sequence of tools over and over to get your data clean, perhaps a macro is in order.