13 Replies Latest reply on Jul 13, 2018 4:33 PM by Deepak Rai

Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 2:59 PM

Hi,

I created a filter for Start and End Dates using Parameters following the steps provided in this link: Creating a Filter for Start and End Dates Using Parameters | Tableau Software

But I'm facing the following problem:

So, my date field is in the format 1/1/2017, 2/1/2017, and so on. I want to know how to ensure that the Current Value in the Start Date parameter is always the 1st of the month and not any other day (like it's showing 5th in the image above).

Can anyone tell me how to do that? I don't want to do it manually for each month because every time I open the workbook again it is set to some random day of the month.

1. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 3:06 PM (in response to Anjali Sn)

You Convert Your Date To First Day of Month Like this and Create Parameter using that New Date
Your New Date
DATE(DATETRUNC('month', YOUR ACTUAL DATE))

This will always default to First Day of Month, Right Click on It and Create Parameter or when you Create Parameter , use From Field>Your New Date

Thanks
Deepak
Like Show 0 Likes(0)

Actions
2. Re: Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 3:37 PM (in response to Deepak Rai)

I don't understand. Like I said my date field only has first day of the months only.
Like Show 0 Likes(0)

Actions
3. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 3:39 PM (in response to Anjali Sn)

So from where you are getting 11/5/2017 then?
Like Show 0 Likes(0)

Actions
4. Re: Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 3:56 PM (in response to Deepak Rai)

No idea. So I have a Month field coming from the data source which is of string data type and 'YYYY-MM' format. I am converting it into a date field called [Date] like this:

date(right(str([Month]),2) +"/1/" + left(str([Month]),4))

Next I create the Start Date and End Date parameters using this Date field. Then I create a Date Range filter as follows: [Date] >= [Start Date] AND [Date] <= [End Date]

Now when I select the start date as Jan 2018 and end date as Jun 2018, I only get data from Feb 2018 to June 2018, and similarly for selecting other start dates as well.
Like Show 0 Likes(0)

Actions
5. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 3:59 PM (in response to Anjali Sn)

Try This To Create Date from your String First

MAKEDATE(LEFT(MONTH Field,4),RIGHT(Month Field,2),01)
Like Show 0 Likes(0)

Actions
6. Re: Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 4:02 PM (in response to Deepak Rai)

Getting Unknown function MAKEDATE
Like Show 0 Likes(0)

Actions
7. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 4:04 PM (in response to Anjali Sn)

Looks like you are on Live Connection, did you try DATEPARSE?
Like Show 0 Likes(0)

Actions
8. Re: Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 4:07 PM (in response to Deepak Rai)

So, I see that when in the Start Date parameter I select "List" in "Allowable Values", it works fine. But when I select "Range", it gives this problem. Anyway to make this slider work??
Like Show 0 Likes(0)

Actions
9. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 4:10 PM (in response to Anjali Sn)

Use This

Select your date which has values of 1st Day of Month
Like Show 0 Likes(0)

Actions
10. Re: Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 4:12 PM (in response to Deepak Rai)

I am doing that only but it doesn't do anything
Like Show 0 Likes(0)

Actions
11. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 4:13 PM (in response to Anjali Sn)

It is difficult to Help without a workbook which I suppose you can't attach...
Like Show 0 Likes(0)

Actions
12. Re: Problem creating a Start and End Dates filter using Parameters

Anjali Sn Jul 13, 2018 4:30 PM (in response to Anjali Sn)

Don't know what the problem was but I did like that (the correct ans I selected) using my [Date] field and it worked!
Like Show 0 Likes(0)

Actions
13. Re: Problem creating a Start and End Dates filter using Parameters

Deepak Rai Jul 13, 2018 4:33 PM (in response to Anjali Sn)

Wow!!! That was the Logic actually
Like Show 0 Likes(0)

Actions