Show/hide filters

andrew.devine.0 wrote:

Hi Joe,

Thanks for your help. Not sure if you meant it but your "I'll repeat what I said in my last reply:" comment reads a bit rude.

It wasn't clear to me from your posts that the dashboard supplied wasn't finished.

...

To be blunt, I never finish examples.  I show how to do something, and let the person asking the question apply it to his actual wortkbook.  (I always assume that the supplied workbook is not the actual workbook the person is doing, but a mock-up of what he's doing.  Most people (including myself) don't want to post their company's actual workbooks on a public forum for proprietary reasons.)

I wasn't intending to be rude.  After repeating the text, I explained what you would actually need to do in your case.  I just figured you missed it the first time I posted it.

Now that I'm looking more closely at your workbook, you actually have that filter calc already.  That's what [Date_Filter_This] is doing for you.  And it's doing it correctly.

I suggested: "Alternatively, you can make a calc that sets a value of 1 in those rows where the date range fits the criteria, and then filter for those rows that are set to 1.".  But whoever set this up is using TRUE/FALSE instead.  Same principle.

See Sheet 9 of the attached.  I have displayed your dates, and applied that existing filter to it. Play with the selections.  You are getting the right rows for the various Time Period selections.

This draws my attention back to something you said earlier:  "The time series is not showing date range based the date selection in most cases dates go back to 2017, is this something I can fix on my side?"

You are using [Date View] in your sheet Graph 1.  But your filter is filtering field [Date].  Look at the respective values on Sheet 9.  In fact, you are getting precisely the correct rows on Graph 1, but the values for [Date View] do not match [Date].

Further, the Time Period choice for "Custom Dates" does NOT use the date filter at all.  It uses two parameters (Start Date and End Date) just like I suggested in my reply that starts, :"Having said that".  So the principle I showed you for popping out the filter would still apply, but you want to pop out the two parameters instead.

In the attached I took the filter off the dashboard and put the two parameters in the pop-out container.  And now when the user selects Custom Dates, he will have the two params to fill in.

andrew.devine.0 wrote:

...

Having read your email several times I'm not clear on what I need to do.

...

One thing you'll need to do is reconcile what those two date fields are supposed to be doing.  Should they have differing dates in them?  Maybe you just want to stick with using [Date] and ditch [Date View] entirely.

On your dashboard, you'll want to decide where you want the parameters to appear.  You'll need them both.  Maybe you want them side-by-side rather than vertically displayed.  If you want them displayed below the Time Period parameter, then you'll need to float that param and have the pop-out container floating below it so that the two date params can pop out from behind the Time Period param.