'Tableau Desktop: I want to keep only 1 raw of record per week for each equipment. Need a calculated field in Tableau
|Equipment| |Date| |Count|
|S0076845| Mar/4/2019 | 1 Need this record
|S0076845| Mar/6/2019 | 1 Need this record
|S0076845| Mar/7/2019 | 1 I don’t want this record
|S0076845| Mar/8/2019 | 1 I don’t want this record
|S0076845| Mar/11/2019| 1 I don’t want this record
|S0076845| Mar/12/2019| 1 I don’t want this record
|S0076845| Mar/15/2019| 1 Need this record
|S0076845| Mar/16/2019| 1 I don’t want this record
|S0076845| Mar/23/2019| 1 Need this record
|S0076845| Mar/24/2019| 1 I don’t want this record
|S0076845| Mar/26/2019| 1 I don’t want this record
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|