dosubot[bot] commented on issue #34425: URL: https://github.com/apache/superset/issues/34425#issuecomment-3139998622
<!-- Greeting --> Hi @gcofini! I'm [Dosu](https://go.dosu.dev/dosubot) and Iām helping the superset team. <!-- Answer --> This happens because, by default, percentage calculations in Superset tables are based only on the rows currently displayed (the page or row limit), not the entire dataset. This is controlled by the "Percentage metric calculation" setting in the Table chart panel, which defaults to "Row limit". As a result, percentages in paginated tables are often incorrect unless you change this setting. Charts and tooltips, on the other hand, aggregate over the full dataset, so their percentage calculations are accurate and reflect the total data, not just what's visible on the current page. To fix this in your table, set "Percentage metric calculation" to "All records" in the Table chart controls. This will make Superset issue an extra query to calculate percentages based on the entire dataset, giving you correct results in the table as well. Be aware that this can have a performance impact on very large datasets, since it requires an additional query over all records. You can find more details in the [Superset table chart control panel code](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-table/src/controlPanel.tsx) and the [query logic for percentage metrics](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/plugins/plugin-chart-table/src/buildQuery.ts). This behavior is by design and not a bug, but it can be confusing if you're expecting percent-of-total to always reflect the full dataset in tables. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/c8bdc768-3649-4db3-8bab-7241ed76f294?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34425) -- 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]
