-
Notifications
You must be signed in to change notification settings - Fork 12.9k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Pivot table summary returning wrong results #16952
Comments
+1 |
I'm not so sure this is a common use case. The |
yes, it is the default expectation how the measure works in any BI tools, I expect the summary row to respect the measure definition not doing a sum, if I want a sum, then I create a measure that explicitly say, for a summary row do a sum of a column |
@djouallah Correct me if I'm wrong but the problem is the summing of the percentages in the Progress column in the Total (sum) row, right? |
@robjuffermans what I am saying having an option to do a sum in the first place is a wrong, I expect the summary row to respect the metric definition , that pretty much how any BI tools works (Tableau, PowerBI, Google Data Studio etc) |
exactly, that's what I'm missing also. @rusackas this should be regarded normal functionality for a pivot table from my point of view. |
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue |
CC @lauderbaugh and @yousoph in case you know how we can revisit this (and related issues) holistically. Adding @kgabryje since he's a SME on the implementation |
@djouallah Did you find any workarounds already. I could imagine to build a chart per aggregation level but it feels far from perfect. Ideally one can fold/unfold on all the dimension and (sub)totals should always respect the formula behind the metric instead of creating a sum of the metric results. |
@mtthsbrr nope, just gave up |
+1 |
1 similar comment
+1 |
There are quite a few issues around this, which I'm trying to consolidate. I'll close this issue in favor of another that sums it up fairly concisely: #25747 |
I am using Preset Cloud, so not sure which version is used, as far as I can see Pivot table summary generate only 1 SQL Query, I would expect that it generate two.
see the results of the division which is wrong Actual/ Budget, I don't know how to tell superset to keep the same metric definition for the summary rows
The text was updated successfully, but these errors were encountered: