Set analysis with variable input and field

[covenant_bi]

Hello, I have a question about Set analysis and using variable input for dates and a regular filter pane with a date.  I'd like the user to be able to use the inputs for custom ranges or use the filter pane for picking 1-2 days. 

The date picker extension is wonky and adds a day to the range selected.  We are on Feb 2020 and it looks like Apr 2020 got the fix for this. So I don't want to use that.

Anyhow, my set analysis looks like this currently, using the "+" for an OR.  Using the input boxes works great, but the POST_DATE filter pane does nothing if the input boxes are empty.  

Sum({<POST_DATE={">=$(vStartDate)<=$(vEndDate)"}+<POST_DATE={'=$(GetFieldSelections(POST_DATE))'}>}AMOUNT)

Let me know your thoughts.  

[Lisa_P]

It's not necessary to do that. Try this:
Sum({<POST_DATE+={">=$(vStartDate)<=$(vEndDate)"}>}AMOUNT)

[covenant_bi · Accepted solution]

Hi Lisa,

 I tried that and found that it only respected the filter pane selection.

I did try Sum({<POST_DATE*={">=$(vStartDate)<=$(vEndDate)"}>}AMOUNT) and that worked.  It respected the inputs when present, otherwise the filter pane.

[Lisa_P]

Great, glad it's working for you.