topic Re: Returning last 7 days of data in App Development

Returning last 7 days of data

Giselle100 — Sat, 16 Nov 2024 21:46:27 GMT

Hi there

I have the below expression

Count({<[Status]={8} >}distinct [Order No] )

How do I amend it to only return the data for the last 7 days?

sunny_talwar — Wed, 05 Dec 2018 13:52:03 GMT

May be something like this

Count({<[Status] = {8}, DateField = {"$(='>=' & Date(Today() - 7, 'DateFieldFormatHere'))"}>} DISTINCT [Order No])

Giselle100 — Wed, 05 Dec 2018 14:26:33 GMT

Its returning a zero value

sunny_talwar — Wed, 05 Dec 2018 14:29:03 GMT

What was the exact expression you used? Did you replace DateFieldFormatHere with the format of your date field?

Giselle100 — Wed, 05 Dec 2018 14:30:27 GMT

Count({<[Status] = {8}, [Outscan Date] = {"$(='>=' & Date(Today() - 7, 'YYYY/MM/DD'))"}>} DISTINCT [Order No])

sunny_talwar — Wed, 05 Dec 2018 14:34:26 GMT

The expression looks good... are you looking for last 7 days from today or last 7 days from the max date in the database?

Giselle100 — Wed, 05 Dec 2018 14:35:06 GMT

max date

sunny_talwar — Wed, 05 Dec 2018 14:38:19 GMT

Then try this

Count({<[Status] = {8}, [Outscan Date] = {"$(='>=' & Date(Max([Outscan Date]) - 7, 'YYYY/MM/DD'))"}>} DISTINCT [Order No])

Giselle100 — Wed, 05 Dec 2018 14:53:10 GMT

Still returning a zero value

sunny_talwar — Wed, 05 Dec 2018 15:03:58 GMT

Would you be able to share a sample to check this out?