I have a list of documents that contains the same key but different dates,and I'm trying to bring all itens from key using data filter, im using Tableau Desktop.

For example, my table is:

If I filter feb/2021, since my key X has the date 01/02/2021, results should be:

Else if im filtering the date aug/2021, it should be:

What I tried: I created a date parameter "Insert Date" to insert a single date and I created a calculated field "Select Date" using FIXED like the code bellow:

{ FIXED [Key] : MAX([Date] = [Insert Date])}

I got it done with a single day but i need using the entire month.

CodePudding user response：

It sounds like you want to first identify the set of keys that show up at least once within your selected date range, and then include all records for the identified keys, regardless of the date on each record.

If so, you don't want to filter record based on the dates, but you do want the user to specify a date (or date range). So instead of using a filter control for the date, use a parameter - either to allow the user to select a day within the month you want, or have two parameters to select the start and end of a range.

Then for the filter define an aggregate calculation or a set that determines whether a key occurs in the proposed time frame. A set named, say KEY_OF_INTERST based on the Key field, defined by a condition similar to the following should work

MAX([Date] >= [START DATE PARAM] and [Date] <= [END DATE PARAM])

That expression is True if at least one record falls within the specified date range, so the set will include exactly the Keys that have at least one document record in the time range.

Then just use the set to filter to the interesting keys