Calculate the count between 2 timestamp

[ishanbansal1204]

Hi Experts,

I have a table where I have date, Timestamp, dim1, dim2, dim3, dim4

with respect to the aggregate function, I can find the count of Date with group by dimensions.

SUM(AGGR(COUNT(QTY),date,item,s1,P1,QTY)) - With this expression , I got the count of transactions for the entire day.

But, What I want is, We have a TimeStamp Column and for each time stamp value, I need Count between timestamp and Timestamp + 1Hr

So, I a day we have 10 records with different time stamp and for each records there should a count displayed for the timestamp which is between the column value and column value + 1hr.

Requesting your help on this.

[jyothish8807]

Hi ishanbansal1204,

Is it possible to share a sample data and your expected result ?

[ishanbansal1204]

Hi Jyothish,

The data is given below.

Date - Time	Dimension1	Dimension2	Count
10-1-2020 00:18:15	A	B	2
10-1-2020 01:18:00	A	B	3
10-1-2020 01:45:00	A	B	2
10-1-2020 01:48:00	A	B	1
10-1-2020 03:02:00	B	A	5

I am looking for the output count