Count between timestamps

Broly — Sat, 16 Nov 2024 03:19:22 GMT

Hello,

I have a question regarding KPI which I have to develop.

For some reason, I cannot put here the picture, so I made an attachment of the table in question

I have to create a kpi or a table, which will count number of trackers which were last active from yesterday 12am until today 12am. So the count should be 3.

Last active is created by Aggr(Max(Time), LINE)

It should not be affected by selections the KPI, and there should be a version where selection matters.

I have something like this:

if((TimeStamp('12:00:00' + Date(Today() -1), 'DD.MM.YYYY hh:mm:ss') < Max(Time)),(count(Tracker)))

Re: Count between timestamps

ssivanagendra — Mon, 10 Feb 2020 14:25:48 GMT

May be this:

=count({<time(lastactive) = {"<=DayStart(today()) >=DayStart(today()-1)"} >}Tracker)

topic Count between timestamps in App Development

Count between timestamps

Re: Count between timestamps