How can I do a view filter, and pass the formula in the slice

How can I do a view filter, and pass the formula in the slice. On ux it will only show the latest [Start Date] update of each [NIK]

Please elaborate on what you mean by this.

Are you saying this is what it is doing, or that is what you’re wanting it to do?

1 Like

yes, thanks for the confirmation, what I mean is, on UX it will only display the latest [Start Date] column of each [NIK]

1 Like

How might I add a date filter to the mix?

If the items table has multiple rows that are essentially all duplicates with the one difference being the date column. Now, I want to by default only allow searching of the most recent date.

Example:
There are three rows that match the search criteria. Rather than returning all three rows, I only want to return the ONE most recent row based on the date column.

I assume I could/should use a MAXROW expression but, not sure where I should put it. I have tried using as a slice filter expression and that won’t work as a MAXROW doesn’t meet the slice expression requirements of being a yes/no result.

1 Like

Try this as your slice’s Row filter condition expression:

(
  [_THISROW]
  = MAXROW(
    "table",
    "Start Date",
    AND(
      ISNOTBLANK([NIK]),
      ([NIK] = [_THISROW].[NIK])
    )
  )
)

Replace table with the name of the table being sliced.

1 Like

Thanks @Steve , it worked

1 Like