$calc_field = 'round('.$width.'.0*(clock-'.$time_from.')/'.$period.',0)';

$calc_field = 'round(cast('.$width.'.0*(clock-'.$time_from.')/'.$period.' AS numeric),0)';

pg_query(): Query failed: ERROR: function round(double precision, integer) does not exist
LINE 1: ...value) AS avg,MIN(value) AS min,MAX(value) AS max,round(604....
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. [zabbix.php:17 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\SvgGraph\Actions\WidgetView->doAction() → Widgets\SvgGraph\Includes\CSvgGraphHelper::get() → Widgets\SvgGraph\Includes\CSvgGraphHelper::getMetricsData() → CHistoryManager->getGraphAggregationByWidth() → CHistoryManager->getGraphAggregationByWidthFromSql() → DBselect() → pg_query() in include/db.inc.php:249]
Error in query [SELECT itemid,COUNT(*) AS count,AVG(value) AS avg,MIN(value) AS min,MAX(value) AS max,round(604.0*(clock-1724607591)/10800,0) AS i,MAX(clock) AS clock FROM history_uint WHERE itemid='161383' AND clock>='1724607591' AND clock<='1724618391' GROUP BY itemid,round(604.0*(clock-1724607591)/10800,0)] [ERROR: function round(double precision, integer) does not exist

zabbix=> SELECT itemid,COUNT(*) AS count,AVG(value) AS avg,MIN(value) AS min,MAX(value) AS max,round(604.0*(clock-1724607591)/10800,0) AS i,MAX(clock) AS clock FROM history_uint WHERE itemid='161383' AND clock>='1724607591' AND clock<='1724618391' GROUP BY itemid,round(604.0*(clock-1724607591)/10800,0);
ERROR:  function round(double precision, integer) does not exist
LINE 1: ...value) AS avg,MIN(value) AS min,MAX(value) AS max,round(604....
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
zabbix=> 

zabbix=> \d history_uint
                  Table "public.history_uint"
 Column |       Type       | Collation | Nullable |  Default   
--------+------------------+-----------+----------+------------
 itemid | bigint           |           | not null | 
 clock  | double precision |           | not null | 0
 value  | numeric(20,0)    |           | not null | 0::numeric
 ns     | integer          |           | not null | 0
Indexes:
    "history_uint_pkey" PRIMARY KEY, btree (itemid, clock, ns)
    "history_uint_1" btree (itemid, clock)
Triggers:
    partition_trg BEFORE INSERT ON history_uint FOR EACH ROW EXECUTE FUNCTION trg_partition('day')
Number of child tables: 91 (Use \d+ to list them.)

zabbix=> select version();
                                                      version                                                      
-------------------------------------------------------------------------------------------------------------------
 PostgreSQL 15.8 (Debian 15.8-0+deb12u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
(1 row)

zabbix=> \df round;
                         List of functions
   Schema   | Name  | Result data type | Argument data types | Type 
------------+-------+------------------+---------------------+------
 pg_catalog | round | double precision | double precision    | func
 pg_catalog | round | numeric          | numeric             | func
 pg_catalog | round | numeric          | numeric, integer    | func
(3 rows)

zabbix=# SELECT itemid,COUNT(*) AS count,AVG(value) AS avg,MIN(value) AS min,MAX(value) AS max,round(604.0*(clock-1724607591)/10800,0) AS i,MAX(clock) AS clock FROM history_uint WHERE itemid='161383' AND clock>='1724607591' AND clock<='1724618391' GROUP BY itemid,round(604.0*(clock-1724607591)/10800,0);
ERROR:  function round(double precision, integer) does not exist
LINE 1: ...value) AS avg,MIN(value) AS min,MAX(value) AS max,round(604....
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

zabbix=# select version();
                                                      version                                                       
--------------------------------------------------------------------------------------------------------------------
 PostgreSQL 16.3 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
(1 row)