CODEWITHSUNDEEP
tableau-api
Andrew S
Andrew S

Reputation: 85

Tableau - Filter on maximum date within dimension

I have data that are structured as so: 

| Node | Update Datetime | Measure Values |  
|------|-----------------|----------------|
| A    |  2018-01-01     |  1             |
| A    |  2018-01-05     |  3             |
| A    |  2018-01-06     |  4             |
| B    |  2018-01-02     |  2             |
| B    |  2018-01-03     |  4             |

The nodesare updated over time with the measure values showing the node's value at the time of data entry, meaning just filtering on a date range will overstate the node's value. The report needs to be responsive or else I would just do this in sql, but as it stands I need to be able to keep only the rows that contain the maximum datetime value within each node, after the entire dataset is filtered on a general date window.

Upvotes: 1

Views: 7222

Answers (1)

p_sutherland
p_sutherland

Reputation: 491

I think creating a level-of-detail (LOD) calculated field and using it as a filter is the cleanest and quickest way to achieve the desired filter.

See Option 2 here -- http://kb.tableau.com/articles/howto/setting-default-date-to-most-recent-date-on-a-quick-filter?lang=en

Let me know if that does not work.

(FYI Tableau Community Forums is another resource for Tableau questions. I use both sites)

Upvotes: 2

Related Questions