Hello, I'm trying to create a dashboard and I'd like to use "TrendMetrics" in it. My problem is that the query I pass as raw SQL is reformatted as MySQL querry and Firebird won't process it. Is there any solution to use TrendMetrics even with Firebird?

Here is my SQL query:

select hf.CELKEMKC_FA as AMOUNT,
        hf.DATVYS_FA as ISSUED
 from HLFA hf
 group by
        hf.DATVYS_FA

and this is what it looks like reformatted

SELECT DATE_FORMAT(Issued,'%Y-%m-%d') AS Issued_day,
    SUM(Amount) AS Amount_sum
FROM
(select hf.CELKEMKC_FA as AMOUNT,
        hf.DATVYS_FA as ISSUED
 from HLFA hf
 group by
        hf.DATVYS_FA) as t
 WHERE (Issued >= '2022-03-07 00:00:00' AND Issued <= '2022-03-13 23:59:59')
 GROUP BY
    DATE_FORMAT(Issued,'%Y-%m-%d')

Hi, thank for you reply.

The version I'm trying it on now is 2.5. The latest version of Firebird is 4.0. I tried searching for date_format in version 2.0 and found nothing.

for example, there's a discussion about it: https://itqna.net/questions/11840/firebird-native-function-format-date

hello, something new about this topic?