Jamie Corvera wrote:
Report will show the number of materials that "Passed" and "Failed" per program, but it has to count only the latest result.
In the sample workbook below, it has to count the 3rd push of Material01 C.
It seems to me that your description and screenshot don't match each other.
The latest result of "Material01 C" is PASSED, so I suppose the count of latest results for "PROGRAM 1" should be 5 PASSED and 0 FAILED.
While the required result in the screenshot shows 4 PASSED and 1 FAILED.
A sample workbook is also attached using Understanding Level of Detail (LOD) Expressions | Tableau Software .
Sample.twbx 77.7 KB
2 of 2 people found this helpful
first create this calculated field:
Do not forget to change the [Date recived] field to Date because it is currently a string, now see your data
Now filter on [Max Matrial Date] = True and display your old sheet.
If you found this correct please mark it as correct answer or as helpful post
Thank you for your help and for the correction Ms. Lei Chen!
Thank you so much haitham!
u r welcome