I have a similar problem on date selections. Here is the scenarios.
Problem1. I have start date and end date. I Should not allow user to select start date lesser than end date and similarly end date should not be greater than start date. What is the best possible solution for this.
Problem 2: There is start date and end date, say from December 2014 to March 2015. There are few dates between these months where there is no data, say Jan 1 to Jan 4 - There is no data. If a user select this date, I need to display an error message - NO DATA FOUND.
Could you please help me in finding a solution or a function for these 2 issues.
Can you expand on the Problem 1,
Am i right in saying that you have Start Date as a filter option on your dash board as well as end date, but do not want them to cross?
I think you would need to create a DATEDIFF parameter where the DIFF must always be >1.
ill think on how to build that..
I wrote this:
Then set the filter to "True" and then the 2 date filters to "ONLY SHOW RELEVANT VALUES"
When you adjust one, it updates the other to prevent overlap!
Problem 2 - Is a simple Calc if you want the reader to find "NO DATA FOUND"
Create a Calculated Field and call it DATA
Then write something like
IF ISNULL([YOURDATA]) THEN "NO DATA FOUND"
Then use this field over the other data one, this should allow all date ranges to be returned then.