How to create a drop down for different type of date fileds

[tdr_Dinesh]

Good day,

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.

Thank you!

[Biswajit_1993]

hi @tdr_Dinesh, can you go through this link so that you have some idea to build your solutions.

Calendar filtering based on 2 date fields

I have a date filter with an OR condition (using 2 date fields from dataset) and only want 1 calendar control on the sheet to update both filters. Is that possible? The only way I can get the filters to work is to have 2 calendar controls n the sheet which isn’t very user friendly.

Thanks & Regards
Biswajit Dash

[David_Wong]

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:

Quicksight: hide filter based on another filter selection

Hello, in AWS Quicksight i have 2 control filters. Filter 1: filter by Name - Filter by Email Based on Filter1 selection i want to show “Filter 2 - Name” OR “Filter 3- Email”. How to do this?

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.

[tdr_Dinesh]

@David_Wong

If you want to just filter by one of the two date fields and not both

Hi @David_Wong , Thank you for your prompt response.

Yes, I want to just filter by one of the two date fields and not both.

1. I have added the parameter as a “TEST”
2. Added the parameter as a control with the following values: Batchdate and Selection Date
3. Created a calculated field using the parameter
   ifelse(${TEST}=“Filter by BatchDate”,BatchDate,${TEST}=“Filter by SelectionDate”,SelectionDate,null)

But unfortunately I am not getting the accurate results and for both the dates I am getting the same results.

Could you please guide me further. Thank you!

[David_Wong]

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.

[tdr_Dinesh]

Hi @David_Wong ,

Thank you!

yes, date fields called Batchdate and Selectiondate.

I hope somewhere I missed out , I am not getting the accurate results.

Below are the steps which I have followed , could you please let me know if I missed out anything here

Step 1:
Given the name as Filter1 and Static default value as ‘Batch Date’

Step 2: Added calculated Field.

Step3: Added control to Parameter

[David_Wong]

I’m not seeing the part where you added a filter on your calculated field. Maybe that’s the step you’re missing.

1. Here’s my sample data containing 2 date fields - Order Date and Ship Date.
   

2. First create a parameter. Use the name of one of your date fields as default value.
   

   

3. Next use the parameter to add a control.
   

   

4. Then create a calculated field like this:
   

5. Add a filter on the calculated field and pin it to the top:
   

   

6. You can use the value of your parameter as the name of the 2nd control.
   

7. If you select Order Date in the first control, the visual gets filtered by the Order Date field.

If you select Ship Date in the first control, the visual gets filtered by the Ship Date field instead.

[tdr_Dinesh]

Thank you @David_Wong .It is working as expected.

[tdr_Dinesh]

Thank you @Biswajit_1993 for sharing the link.

[tdr_Dinesh]

Hi @David_Wong,

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!

[David_Wong]

Hi @tdr_Dinesh,

Yes, it will work. You can add another date field.

[tdr_Dinesh]

Hi @David_Wong

Thank you!