Filter and Sort in a Gallery

[Robertjde]

Hello, everyone,

I want to filter my gallery by a range (line) and date, which I do with a dropdown box.
3 lines are written in my database per area and day (date), from which I want to sort the 3 largest losses from duration_1, duration_2, duration_3 (format text) with error text.

Filtering works well, but I don't know how to sort the columns according to the largest number and get the appropriate text from first_fault, second_fault, third_fault.

SortByColumns(Filter(OPS1_Entries_Verpackung;Title = Dropdown4_5.Selected.Result;StartsWith(Linie;Dropdown5_14.Selected.Result));"Schicht";["Frühschicht";"Spätschicht";"Nachtschicht"])

[RandyHayes]

@Robertjde 

Are you stating that you want to sort from the largest to smallest looking at all three columns (duration_1, duration_2, duration_3)?

Or are you wanting to sort in a hierarchy of those columns (i.e. duration_1 largest to smallest, then largest to smallest for each of duration_2?)

Also, you mention that the durations are text??

[Robertjde]

@RandyHayes 

I need the top 3 from all columns and rows. and then sorted from large to small.
In the example it would be 44, 30, 15
Unless a larger value is stored in another column, e.g. Duration_2

[RandyHayes]

@Robertjde 

So to be clear on it...

Given your picture of your data and the three records shown (numbering them 1 through 3), the sort order would be: 3, 1, 2

In those records, it would all be determined by the duration 1 because that duration has the largest of the three durations.

BUT, if record 2, let's say, had a duration 3 of 60, then the sort order would change to:  2, 3, 1

Is that correct?  If so, what I am stating is that you want to sort by the max duration of duration 1, 2, and 3.

Please validate so I give you the right solution.

[Robertjde]

@RandyHayes 

Yes that is correct.

I've attached another example to better explain the scenario