Slice View and Expressions

[provisrudd]

Hello,

I have a table [Tracker] where I have the columns "Serial ID" & "Status"{Precleaned,Cleaned, Sent For Repair without cleaning, Sent for repair}

I want to get a slice view of the table but without duplicates for Serial ID with the most recent status that was entered. 

Thank you and much appreciated 🙂

[Lynn]

Hi @provisrudd 

Have you checked these out?

https://help.appsheet.com/en/collections/377977-expressions

[provisrudd]

Yes I have but non of the ones I try are working. 

[Steve]

([_ROWNUMBER] = MAX(SELECT(Tracker[_ROWNUMBER], ([_THISROW].[Serial ID] = [Serial ID]))))

[provisrudd]

Hi Steve,

I tried this filter, but it still seems that all data still shows up with duplicates. 

[Steve]

I would suspect your view is showing the table data (which is unfiltered) rather than the slice data (filtered). Check the view's configuration and make sure it's using the slice.