venkatamandavilli-code commented on issue #35089: URL: https://github.com/apache/superset/issues/35089#issuecomment-4156939275
After reviewing the scenario here is my Analysis The Pivot Table currently labels the overall aggregated row using the correct aggregation function, such as **“Total (Sum)”** or **“Total (Average)”**, depending on the metric selected. However, the subgroup rows are always labeled **“Subtotal”**, regardless of the aggregation function being applied. This creates an inconsistency in how aggregated values are communicated to end users: - When using **Sum**, “Subtotal” is intuitive. - When using **Average**, “Subtotal” becomes misleading because it does not indicate that the subgroup value is also an average. - The same issue appears for other aggregation types such as Min, Max, Count, etc. From a functional and UX perspective, this reduces clarity and can lead to misinterpretation of the data, especially in dashboards shared with non‑technical stakeholders. Impact on End Users - Users may assume subgroup values are sums even when the aggregation is average or another function. - Pivot Tables become less self‑explanatory and require additional explanation. - Inconsistent labeling reduces readability and analytical accuracy. Expected Behavior Subgroup labels should reflect the aggregation function being applied, similar to the total row. For example: - **Total (Average)** - **Subvalue (Average)** - **Subvalue (Sum)** - **Subvalue (Max)** - **Subvalue (Min)** This ensures both total and subgroup rows clearly communicate the type of aggregation used. Conclusion This is a UX enhancement request to improve clarity and consistency in Pivot Table labeling. Updating the subgroup label from **“Subtotal”** to **“Subvalue (Aggregation)”** will make the visualization more intuitive and reduce the risk of misinterpretation, especially when using non‑sum aggregation functions. -- 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]
