kk467415728 opened a new issue, #15773: URL: https://github.com/apache/doris/issues/15773
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description 我们通过使用Tableau和Superset这类BI工具来对接Doris，我们大部分的需求都需要用到 EXCLUDE 函数，所以想请教一下是否可以实现这个函数，谢谢。 需求大致如下： 例：input、fail为度量值，error_code为筛选列 在聚合度量input时需要排除掉error_code的过滤值，在聚合度量fail时需要 error_code的过滤生效，且sum(input)和sum(fail)需要一起展示。 ### Use case SELECT COL1, EXCLUDE(ERROR_CODE : SUM(INPUT)) AS INPUT_EXCLUDE,SUM(FAIL) FROM TABLE WHERE ERROR_CODE = 'error1' GROUP BY COL1; ### Related issues _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
