Speeding up a filter for a slice

I need to filter >12,000 records with a slice. The statement below works fine but takes a 2-3 minutes to run. This is actually a simplified statement and I need to expand it. Unfortunately I need all the logic. Would it help to run the slice filter based a separate table in GSheet that contains part or all of the filter expressions? Or would it help to divide this into 2 slices or reorder the expressions? Or are there a better expressions to use?

ISNOTBLANK(
  FILTER(
      "NRC Reporting",
      AND(
           ([_THISROW].[License Plate #] = [License Plate #]),    
           ([_THISROW].[License Plate #] <> ""),
           ([_THISROW].[License Plate State] = [License Plate State]),
       ((ABS(HOUR([_THISROW].[Timestamp] - [Timestamp])) / 24) > 14),
       ((ABS(HOUR([_THISROW].[Timestamp] - NOW())) / 24) < 31),
       (DISTANCE([_THISROW].[GPS Location], [GPS Location]) < 50)
      )
    )
      - LIST([_THISROW])
  )

Thanks
Bob

0 3 216
3 REPLIES 3
Top Labels in this Space