dosubot[bot] commented on issue #33289: URL: https://github.com/apache/superset/issues/33289#issuecomment-2840388503
<!-- Answer --> I found a similar unsolved discussion titled [Totals in table charts](https://github.com/apache/superset/discussions/29297), which might be relevant to your issue <sup>[[1]](https://github.com/apache/superset/discussions/29297)</sup>. Regarding your issue, the current behavior of the "Show summary row" feature is to display totals for the entire dataset when `formData.show_totals` is enabled and the query mode is `QueryMode.Aggregate`. This is because an extra query is created for total aggregation, which does not apply pagination or filtering to the results <sup>[[2]](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-table/src/buildQuery.ts)</sup>. To address your concern, you might consider implementing a mechanism to differentiate between totals for visible rows and totals for the entire dataset. This could involve modifying the query logic to apply filters and pagination to the summary calculations, or adding an indicator to clarify that the summary reflects the entire dataset. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/66391250-6c25-45cb-8478-752064a7b015?feedback_type=other)</sup> -- 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]
