khaledjameel27 commented on issue #35505:
URL: https://github.com/apache/superset/issues/35505#issuecomment-3547532297
@rusackas this is the below query :
this my query :
select CUSTOMER_ID , DATE(date_created) as DATE ,SUM(FEE)/1000 as TOTAL_FEE
from CUSTOMER.ORDERS
where YEAR(date_created) >= YEAR(CURRENT_DATE) - 2
and JOB_ID in (27,81,11,28)
group by DATE(date_created) ,CUSTOMER_ID
in bar chart it will be like this
SELECT "DATE" - (DAY("DATE")-1) DAYS AS "DATE", sum("TOTAL_FEE") AS
"SUM(TOTAL_FEE)"
FROM (select CUSTOMER_ID , DATE(date_created) as DATE ,SUM(FEE)/1000 as
TOTAL_FEE
from CUSTOMER.ORDERS
where YEAR(date_created) >= YEAR(CURRENT_DATE) - 2
and JOB_ID in (27,81,11,28)
group by DATE(date_created) ,CUSTOMER_ID)
AS virtual_table
WHERE "DATE" >= '2024-01-01 00:00:00.000000' AND "DATE" < '2025-12-31
00:00:00.000000' GROUP BY "DATE" - (DAY("DATE")-1) DAYS ORDER BY
"SUM(TOTAL_FEE)" DESC FETCH FIRST 10000 ROWS ONLY;
please let me know if any sample data needed.
as of now, i rollback to 4.1.1 and it's working fine
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
