1 Reply Latest reply on Apr 6, 2016 6:29 AM by Carl Slifer

Remaining leases from today to end of fiscal year

Ernie Henrichon Apr 6, 2016 5:51 AM

I'm trying to use a filter to capture only the leases from today to the end of the year. I don't want to use a set starting date because when I look up the information at a later date I want that new date to be the starting date. I don't see how this is possible in the filter function. Any ideas?

1. Re: Remaining leases from today to end of fiscal year

Carl Slifer Apr 6, 2016 6:29 AM (in response to Ernie Henrichon)

Howdy Ernie,

Perhaps your could create two parameters. Start Date and end of the fiscal year.

You could then check if your leases are between these two.

[Date] >= [StartDate] and [Date] <= [EndDate]

Then you can use this as a filter and keep only the True.

IF you do not want to use a set starting date substitute TODAY() for the starting date.
Like Show 0 Likes(0)

Actions

Tableau Community Forums

Remaining leases from today to end of fiscal year

1. Re: Remaining leases from today to end of fiscal year

Actions

More Like This