topic Re: Previous single days data in expression in App Development

Previous single days data in expression

thedoge1 — Sat, 05 Jun 2021 15:26:55 GMT

Hello,

I am attempting to alter an expression that currently provides data for the last 30 days to the current day. I would like to show the data for just single previous days from the current date. Below is the expression that provides the data for the last 30 days and the expression with the changes that I have attempted but will not run. Any help would be appreciated.

//count({<[Class Category ID]={0}, [Path & Area]={'People Count 1'}, [Group]={'Plaza people counting cameras'}, Date={">=$(=Date(Today()-30,'DD/MM/YYYY'))"}>} ObjectID)

count({<[Class Category ID]={0}, [Path & Area]={'People Count 1'}, [Group]={'Plaza people counting cameras'}, Date={"=$(=Date(Today(1)-30,'DD/MM/YYYY'))"} ObjectID)

Thanks

Dan

Re: Previous single days data in expression

Vegar — Sun, 06 Jun 2021 06:16:44 GMT

Please explain what you mean by "single previous days". Is it yesterday and today()? If so, then try this:

count({<[Class Category ID]={0}, [Path & Area]={'People Count 1'}, [Group]={'Plaza people counting cameras'}, Date={">=$(=Date(Today()-1,'DD/MM/YYYY'))"}>} ObjectID)

Re: Previous single days data in expression

thedoge1 — Sun, 06 Jun 2021 20:01:46 GMT

I am wanting to get the data for just a single day but I want to use the current day as a reference point. For example if the date is 6/6/2021 and I want just the data for 6/4/2021 the function would reference the current day minus 2 days.

Re: Previous single days data in expression

Vegar — Mon, 07 Jun 2021 07:56:09 GMT

Try this.

count({<[Class Category ID]={0}, [Path & Area]={'People Count 1'}, [Group]={'Plaza people counting cameras'}, Date={'$(=Date(Today()-2,'DD/MM/YYYY'))'}>} ObjectID)

It is important that your date format string 'DD/MM/YYYY' is similar to your Date field format.

Re: Previous single days data in expression

thedoge1 — Tue, 08 Jun 2021 16:31:41 GMT

Thank you, that expression did it for me.