Basically I have add the filter option to the dashboard for two different date fields which are Batch date and Selection date as shown in below.
Could some one help me how to create the one drop down for both the date fields. These should be listed as a “Date Type” for the filter name and then users should be able to pick one of these two options.
If you want to just filter by one of the two date fields and not both, you can also take a look at this post:
This solution isn’t specific to date fields. You have one control to select what field would want to filter by and the second control is your actual filter.
Are your 2 date fields called BatchDate and SelectionDate?
The value of the parameter in your calculated field has to match the values in your first control. If the first control contains BatchDate and SelectionDate, your calculated field should say:
ifelse(${TEST}=“BatchDate”,BatchDate,${TEST}=“SelectionDate”,SelectionDate,null)
Then you need a second control to apply a filter on that calculated field.
The first control is to allow you to set the value of the parameter and choose between BatchDate and SelectionDate. The second control is to allow you to select the date.
By considering one more field, the field name as “Audit complete date”. If I want this field in drop down along with the existing 2 fields. Is it works? if I use the same concept. Could you please confirm. Thank you!
I have added one more field in the list as “Audit Date”. On this filed few of the columns are “NULL” since the audit is not completed yet. Because of this,field type reflecting as “String” hence we are experiencing an issue to add this field to the drop down.
Could you please assist me is there any alternate option to add this in to the drop down.
If you have some valid dates in the Audit Date field, QuickSight should treat it like a date field in your dataset. Can you share a screenshot of some of the date values in the field?
Could you please have a look in to the below snap. In the dataset “Audit completedate” field reflecting as “String” when we tried to change the data type to date then the rows which shows “NULL” are skipped out from the data base.
@tdr_Dinesh Let us know if @David_Wong’s solution works for you. If so, can you let us know by marking it as “Solution” (check box under his reply)? Thanks!