Filtering for maximum date within dimension

+1 vote

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.

Aug 1, 2018 in Tableau by ghost
• 1,790 points
22 views

1 answer to this question.

0 votes

Create a level-of-detail (LOD) calculated field and use it as a filter.

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

answered Aug 1, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
50 views
+1 vote
1 answer

Tableau - Filter/Parameter For Different Date Ranges

Based on your comment and updated question, ...READ MORE

answered Jul 19, 2018 in Tableau by Atul
• 5,530 points
74 views
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 25,900 points
25 views
0 votes
1 answer

Set dynamic date value for parameter

Hi Anitha, You can create a calculated field ...READ MORE

answered May 16 in Tableau by Cherukuri
• 25,900 points
28 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,819 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
77 views
+2 votes
1 answer
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
715 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
43 views