operations on cells within 1 column
-
I have Date & Time (dd/mm/yy mm:ss) column in ascending order. Each row represents a spot which came on TV. How can I calculate the difference between two consecutive spots? Is there a way to do this type of operations on cells within one column like in Excel (A2-A1)?
-
1 Comment
-
Hi,
You can do this using a formula.
The following formula will create an additional column that shows the difference in minutes between the date field in the current row and the date field in the previous row:
DATEDIFF(
SUBSET_SINGLETON([DATE_FIELD], ROWINDEXSUBSET(CURRENTROW() - 1)),
[DATE_FIELD],
"minute")
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.