Hey Guys,
Need One Help
I have one date field which containing the date with TimeStamp and its get Upated every seconds in Transaction Table.
I have a report in which Date field is there
i.e Asset | Sensor | DateRecorded | Value
A | 123 | 24-09-2015 12:00:01 AM | 12344
A | 123 | 24-09-2015 12:00:02 AM | 12345
A | 123 | 24-09-2015 12:00:03 AM | 12346
.
..so on
..
A | 123 | 24-09-2015 12:00:30 AM | 12347
A | 123 | 24-09-2015 01:00:01 AM | 12348
and so on
updated in transaction Table
I want to Create a Interval like 10 min, 30 min, 1 hour, 2 hour etc
Now i want when i select any Interval Suppose 10 Min, the Report Should Display like Below
Asset | Sensor | DateRecorded | Value
A | 123 | 24-09-2015 12:00:01 AM | 12344
A | 123 | 24-09-2015 12:00:11 AM | 12345
A | 123 | 24-09-2015 12:00:21 AM | 12346
A | 123 | 24-09-2015 12:00:31 AM | 12347
and so on
and Same if i select 30 Min the report should update like below
Asset | Sensor | DateRecorded | Value
A | 123 | 24-09-2015 12:00:01 AM | 12344
A | 123 | 24-09-2015 12:00:31 AM | 12345
A | 123 | 24-09-2015 01:00:01 AM | 12346
A | 123 | 24-09-2015 01:00:31 AM | 12348
DateRecorded Field i am getting in Transaction Table
TxnTable:
Load
Field1,
Field2,
DateRecorded
from Source;
Please Suggest how i can achieve it..
