Orderby day...

[Benni]

Hi all

I finally got a paper report ((thank you again @Marc_Dillon ) . I have an anomaly in the data list, I'll show you: 

Why does this happen? How is it corrected?

[SkrOYC · Accepted solution]

ORDERBY() - AppSheet Help

By default, data is displayed in the same order as the table has it's rows or the column has it's values.

Since [resultato con funzione FILTER] seems to be a list of ref values, you can use ORDERBY() with it in the template:

ORDERBY(
  [resultato con funzione FILTER],
  [DATA INIZIO ATTIVITA],
  false
)

 false make the list be sorted from low-to-high.
You can add as many arguments as columns you have

[Benni]

Hi @SkrOYC Sorry, I didn't understand where to insert that command. In the section below?

I'm not sure I quite understand what you mean, but it didn't generate correct results. There is still error in your suggest.

[Benni]

my mistake sorry. You are definitely right.😃

[SkrOYC]

As reference, the solution is to use the expression in the template.
Another way is to order the items in AppSheet, which would show the data ordered inside the app as well.
For that, you just wrap your FILTER() expression with the ORDERBY().