dosubot[bot] commented on issue #34718: URL: https://github.com/apache/superset/issues/34718#issuecomment-3191339186
<!-- Answer --> Superset groups all numeric types—including DOUBLE and DECIMAL—under the generic "number" category for chart controls, so there is no separate "float" type in the histogram chart menu. This is expected and not a bug: as long as your column is recognized as "number" (which means it's classified as numeric by Superset's backend), it should be eligible for histograms, provided there are no nulls [details](https://github.com/apache/superset/discussions/34717#discussioncomment-14114743). If your column is still not accepted for a histogram, it's likely because DuckDB returns a type string that Superset's backend doesn't recognize as numeric (it must start with "float", "double", "decimal", or "numeric"). If casting to DECIMAL or DOUBLE doesn't help, and the type string is still not matched, the only reliable fix is to patch Superset's DuckDB engine spec to recognize the actual type string DuckDB produces [reference](https://github.com/apache/superset/discussions/34717#discussioncomment-14114743). In summary: "number" is the correct and expected category for numeric columns in Superset histograms, and there is no way to make it show as "float" in the chart menu. If your column is recognized as "number" and has no nulls, it should work for histograms. If not, check the exact type string DuckDB emits and consider patching the engine spec if needed. <!-- 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/df812821-3fa7-46d6-8dcf-195f8974b994?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/df812821-3fa7-46d6-8dcf-195f8974b994?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/df812821-3fa7-46d6-8dcf-195f8974b994?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/df812821-3fa7-46d6-8dcf-195f8974b994?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/df812821-3fa7-46d6-8dcf-195f8974b994?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/df812821-3fa7-46d6-8dcf-195f8974b994?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/df812821-3fa7-46d6-8dcf-195f8974b994?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/34718) -- 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]
