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
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |