Just for the halibut
, check the attached out. Currently, it is filtered just for December '14. You can change the filtered range by clicking the little filter icon to the right of the Date header. Last week, last month, last quarter, last year, specific months, etc. etc.
Ignore the column headings that were added. This is done automatically when you use the Format as Table function. This function makes managing equations (and a lot of other things) really easy and logical. You can rename them if you like.
Also, I only copied the data from your tables, not the formulas. Some had reference errors anyway. So this is, as I said before, just for illustration.
On the Summary tab are all your metrics. I've only done a few, but am confident the others can be done to once the fields are defined. First, the start and end filtered dates are displayed, 12/1/14 and 12/31/14. These will change automatically if you change the date filter.
Then is Total Readings, ... , Median are calculated. Again, just for the filtered data. I don't know what the other metrics are so I didn't enter any formulas.
Look at the formula for Filtered start...
=SUBTOTAL(105,AllData[Date])
Subtotal is a formula that does certain functions only over applied filtered data. 105 is the code for Minimum. So this formula says, in effect, find the minimum for the filtered table for the data in the Date column of the AllData table. Like the column headings, you can change the name of the data table to suit your liking. Any of these changes will be reflected in the equations automatically. Neat huh?
Now go to the Chart tab and there is your plot for Data1 and Data2. Like the metrics, the chart will display all data within the filtered dates.
I tried to see if there was any way to make a continuous plot of data over multiple tabs, but it doesn't appear to be possible as far as I can tell.