You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/02/03 14:57:18 UTC
[GitHub] [superset] tsarangi opened a new issue #18572: PivotTable vs PivotTableV2. String aggregation is incorrect in PivotTableV2
tsarangi opened a new issue #18572:
URL: https://github.com/apache/superset/issues/18572
When the Aggregation Column is a String/Text, PivotTableV2 fails to show the values, where as PivotTable correctly shows it.
For example, in SQL syntax, one can do MAX(filed_that_is_a_string), and it would show you just the value, but in case of PivotTableV2 it shows `Null`, `NaN`, `NaNUndefined`, depending on the aggregation option, and none of them work.
Here is how to reproduce the bug:
I used the public.FCC 2018 Survey Dataset and the following columns:
- `MAX(marital_status)` as the aggregation, or metric
- In case of PivotTableV2, Row is `is_self_employed` and Column is `bootcamp_attend`
- In case of PivotTable, `is_self_employed` is in GROUP BY, `bootcamp_attend` is in Column and `MAX(marital_status)` is in metric.
- Follow the Screenshots attached to create a version of your own Chart and you will see PivotTable doesn't show the metric results, where it should.
#### Screenshots
### Environment
(please complete the following information):
- browser type: Chrome
- superset version: HEAD of master branch: ac2545e357bff22697fb91aa6ce73eded1f12750
- python version: 3
Let me know what else you would like to see, I would try to provide.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org