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.
How to use If isnull with 2 different cases
I have 2 Columns where Date is Null
Start Date & Actual Start Date
Want to do the calculation like
if isnull Start date and Actual start date then "0" else "1"
but it gives me error Kindly guide how to use with 2 different cases.
I have a similar case but when I am applying ISNULL, it is selecting all the values which have null values.
I am using it for a date column. My requirement is to exclude the null values.
What can I do?