Count between timestamps

[Broly]

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)))

[ssivanagendra]

May be this:

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