Visualizations - compare to previous X

[boutcher]

I often get requests to show data, and compare that data to the same timeframe a week prior/month prior/etc. Some examples:

1. For a line chart that shows count-of-documents by minute over the last 24 hours, being able to plot a line on the same chart for the count-of-documents by minute for the same 24 hour period, a week prior.

2. Same as above, but imagine showing count-of-documents for the last week at daily intervals - and being able to show another line plotted for the same duration/interval, but 30 days prior

3. Data table -- same concept. Maybe even being able to have an aggregation look backwards in time, so you could have count-of-documents, average-of-field-X, average-of-field-X-one-week-prior

Extra bonus -- for line charts, showing the difference between this interval and historical interval as shaded green or red.. same thing for data table numbers - highlighting the cells based on differences between now and then.

Not sure how much of this is doable with the current system.. Is this something that you have to write scripts for?

[rashidkpc]

Duplicate of #1244. Feel free to add comments to that ticket. Unfortunately this isn't possible in the current design, but we're looking at ways to move the time filter insertion to be closer to the aggregation to make it possible