Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t (
  "date" date,
  "Repeat calls_24h" INTEGER
);

INSERT INTO t
  ("date", "Repeat calls_24h")
VALUES
  ('2022-09-17', '182'),
  ('2022-09-18', '381'),
  ('2022-09-19', '81'),
  ('2022-09-20', '24'),
  ('2022-09-21', '91'),
  ('2022-09-22', '110'),
  ('2022-09-23', '231');

CREATE TABLE



INSERT 0 7


select *
from   t


date
Repeat calls_24h


2022-09-17
182

2022-09-18
381

2022-09-19
81

2022-09-20
24

2022-09-21
91

2022-09-22
110

2022-09-23
231



SELECT 7


select  "date"
       ,"Repeat calls_24h"
       ,"Repeat calls_24h" + lag("Repeat calls_24h") over(order by "date") + lag("Repeat calls_24h", 2) over(order by "date") as "Repeat Calls 3d"
from    t


date
Repeat calls_24h
Repeat Calls 3d


2022-09-17
182
null

2022-09-18
381
null

2022-09-19
81
644

2022-09-20
24
486

2022-09-21
91
196

2022-09-22
110
225

2022-09-23
231
432



SELECT 7

date	Repeat calls_24h
2022-09-17	182
2022-09-18	381
2022-09-19	81
2022-09-20	24
2022-09-21	91
2022-09-22	110
2022-09-23	231

date	Repeat calls_24h	Repeat Calls 3d
2022-09-17	182	null
2022-09-18	381	null
2022-09-19	81	644
2022-09-20	24	486
2022-09-21	91	196
2022-09-22	110	225
2022-09-23	231	432