Filter and max()

[ADAJALAN]

I want filtering data and i want get value max from data,

I Used This formula but [Id Project] still stuck

FILTER("Histori",
AND(
IN([BANGUNAN / PEKERJAAN],[_THISROW].[Pekerjaan]),
IN([PERUSAHAAN],[_THISROW].[Perusahaan]),
IN([JOB SITE],[_THISROW].[Site]),
[REPORT PERIODE]>=[_THISROW].[START DATE],
[REPORT PERIODE]<=[_THISROW].[END DATE]
)
)

what i want is [Id Project] to show only one or last one

someone can help me for what formula i need to add

[dbaum]

Maybe you're trying to Control grouping - AppSheet Help?

If you want to return only a single row from the multiple rows returned by your FILTER expression, then wrap that expression within a function that returns a single value rather than a list--e.g., ANY, INDEX, MAXROW.

[ADAJALAN]

i want to display some data, according to my selected criteria.
but for [id project] it only appears once, because this is the identity (unique) of each job

[dbaum]

---

@ADAJALAN wrote:

it only appears once

---

What is "it"?

Try providing a mock-up of what you're trying to achieve.

[ADAJALAN]

This Is a mock-up

I want to make filtering data, with some of the same data.
I do filtering with the formula:

FILTER("Histori",
AND(
IN([BANGUNAN / PEKERJAAN],[_THISROW].[Pekerjaan]),
IN([PERUSAHAAN],[_THISROW].[Perusahaan]),
IN([JOB SITE],[_THISROW].[Site]),
[REPORT PERIODE]>=[_THISROW].[START DATE],
[REPORT PERIODE]<=[_THISROW].[END DATE]
)
)

However, there is still a duplicate of the same item [ID PROJECT] ,
What formula should I add so that [ID PROJECT] appears only 1x or MAX ...

previously I made in Slice with the formula max

[_THISROW]=MAXROW(
"My Table",
"_ROWNUMBER",
([_THISROW].[ID PROJECT] = [ID PROJECT])

it does get the value from last, but it doesn't work well with my filtering which has a date range :

[dbaum]

---

@dbaum wrote:

If you want to return only a single row from the multiple rows returned by your FILTER expression, then wrap that expression within a function that returns a single value rather than a list--e.g., ANY, INDEX, MAXROW.

---