Export CSV of filtered rows

[Lynn]

Hi @tony This app doesnt allow copying or looking under the hood.

[tony1]

Whoops. Should be fixed, thanks @Lynn

[Elizabeth_Loro]

Hi!

I am having some troubles with the CSV function. When I press the action button, it only shows the names of the columns but not the rows (data) that belong to the slice. Are there any possible reasons for that? I am attaching an image of the file downloaded. In the app I can see there are three rows in that slice.

I hope you can help me! Thanks.

[Michael2]

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.

[Aleksi]

Something like…
[KeyColumn]=MAXROW(“TableName”,“Date”)