It's really difficult to help based on this example, can you please attach a Tableau Packaged Workbook?
Have you created a parameter for your input and a filter referencing that accordingly? Parameters
I unfortunately cannot put in a packaged workbook. It contains too much private information that I cannot isolate. I have created string parameters that select a date range of a year. It has been requested that the date range be variable based upon the refreshed data. Someone might accidentally enter 2015 or 2014 that would not show up in the static string range.
If the string was blank then hypothetically it would pick up all dates entered (those blank being null which is fine, we can work around that), but if someone enters 2006 then it needs to show up when opening to do a data check on that item and refresh our data.
Once that initial open and data check has been done. Then the user would like to enter dates into the parameters and narrow down their relevant search.
Not 100% sure what the request is here. Based on my interpretation of your description of the problem it sounds like something that can be done just using a standard date filter.
Your first table 'Output when Open' looks like it can be created my putting the Date pill to Rows and SUM([Volume]) to text.
If you put the Date pill to the filters you have a number of options about how it's presented - i.e. the user can select just a year (discrete year), a range (continuous), etc. The filter will look at all values within the data and return all of those available.
Guess there's more to your request that just that but it's not clear for me what else is needed.
This should be much simpler.
if [Parameter Max date]="" or [Parameter Min Date]="" then "Show"
elseif [Date Comp] >= date(dateparse("yyyy/MM/dd","2016/"+[Parameter Min Date]))
and [Date Comp] <= date(dateparse("yyyy/MM/dd","2016/"+[Parameter Max date]))
then "Show" else "Hide" end