ValeriyaKur commented on issue #19644: URL: https://github.com/apache/superset/issues/19644#issuecomment-1445393629
> @EBoisseauSierra I realize this Issue has gone unattended for quite a while. Sorry about that :/ > > Are you still interested in this as a feature, or have you found a workable workaround/solution? I'm not quite sure if we should close this issue as "stale" or move it to a Github Discussion under the Ideas thread. But I think it's fair to say the ol' open source adage that we're happy to review a PR if you're interested in tackling this, or considering a SIP if you think it's a larger effort you're willing to help usher through. Hi! The question is relevant. My company is transferring reports from Power BI to a superset. The PBI calmly coped with such a task. On my own behalf, I will add that the ability to calculate metrics based on other metrics is needed not only in the set, but also in the charts metrics. Because in the charts, when trying to enter a custom metric calculation: `SELECT "DateTransit_WeekISO" AS "DateTransit_WeekISO", "Reason_DR" AS "Reason_DR", case when the sum(qnt_rdr) exceeds(split into "DateTransit_WeekISO", "Reason_DR") = 0, then 0 else (sum(qnt_rdr) over(section by "Name", "AG", DateTransit_Week IS, is_virtual, OperType, Reason_DR, Reason_OD))/(SUM(qnt_rdr) over(section by DateTransit_WeekISO, Reason_DR)) ends AS Reason_DR_perce from "OP_all_users". Group "SSet_SupplyMonitor_transit_new" by transition date in a week, Reason_DR LIMIT 10000;` ClickHouse throws an error: SQL error [215] [07000]: Code: 215. DB::Exception: The column `qnt_rdr` is not in the aggregate function and is not in the BY group. There are columns: ['Reason_DR','DateTransit_WeekISO'] -- 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]
