Filter 12 months based on the latest date in the data?

tableaucommunity@tableau.com — Fri, 10 Jan 2014 23:32:36 GMT

I'm trying to show the latest 12 months of data in a worksheet, but I'd like the "latest" 12 months to be based on the latest date in the "Activity Month" date field.

As an example, the latest date in the field is 6/15/2013, which means it will show all records between 6/15/2012 and 6/15/2013.

The "Anchor Relative to" feature in the date filter only allows a manual update... nothing dynamic. Anyone have a good formula I could use to filter?

I tried DATEDIFF('day',[Activity Month],today()) , but that anchors based on today's date, not the latest in the database.

I can't use DATEDIFF('day',[Activity Month],max([Activity Month])) , because it's mixing aggregate and non aggregate arguments.

Any help is appreciated!

Todd

filter by a group count

tableaucommunity@tableau.com — Mon, 27 Feb 2012 16:43:25 GMT

Hello All. I have a set of purchase information by customer at a detail level and need to find a way to filter customers who haven't purchased more than x number of units. I can do this with a condition filter easily enough, but ALSO need to use that same field to filter certain customer names by selection. Here's an example:

Customer Name	Number of Records
Customer A	1
Customer A	1
Customer A	1
Customer B	1
Customer B	1
Customer B	1
Customer B	1
Customer B	1
Customer D	1
Customer E	1
Customer E	1
Customer E	1

I'd like to filter this so I only show customers who have more than 2 records, AND I also want to exclude "Customer E", which leaves Customer A and Customer B.

What is the best way to accomplish this? Again, I could use a condition filter, but I'd really rather write a formula if possible to identify those who have more than two units, but do a global filter to exclude certain names.

Thank you!

Content in Tableau Community Forums

Filter 12 months based on the latest date in the data?

filter by a group count