Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi ishanbansal1204,
Is it possible to share a sample data and your expected result ?
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