Bug description

If you have a table with numeric columns and all their rows are empty (NULL), then the Customize option for the Table and Interactive table charts categorizes them as string columns.

Reproduction

  1. Create a table with at least one numeric column, and insert null values into it.
  2. Create a dataset with that table.
  3. Edit the dataset and create a metric using that numeric column
  4. Create an Interactive table chart or a Table chart with that dataset. Move the created metric to the metrics section and add one column to the dimension section.
  5. Click on the Update chart button and then on the Customize tab

Expected result

In the customize tab, you see the metric created categorized as numeric (#)

Actual result

The metric is categorized as string (abc)

Screenshots/recordings

No response

Superset version

master / latest-dev

Python version

3.11

Node version

18 or greater

Browser

Firefox

Additional context

No response

Checklist

  • [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
  • [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
  • [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

Comment From: LisaHusband

@msyavuz If this issue hasn’t been assigned yet, I’d love to take it on

Comment From: msyavuz

@LisaHusband https://github.com/apache/superset/issues/34142#issuecomment-3064948823

Comment From: geido

🎉 Preset Bounty Available: $150 USD 🎉

To claim this bounty, please carefully follow the steps below.

📋 Steps to Participate

  1. Review Guidelines:
    Read through the Preset Bounty Program Contribution Guide for complete details on bounty requirements.

  2. Show Your Interest:
    Complete the Preset Bounty Program Survey and comment this issue to express your interest.

  3. Join the Slack Channel:
    After completing the survey, you’ll receive an invitation to the dedicated Apache Superset Slack channel.

  4. Get Assigned:
    To officially start, ensure a Bounty Program Manager has assigned you to this issue.

  5. Submit Your Solution:
    When ready, submit your solution with the Fixes #{issue_number} notation in your Pull Request description.

  6. Claim Your Bounty:
    Sign up at GitPay.me and submit your solution via: https://gitpay.me/#/task/1222

💡 Additional Notes

  • Only developers assigned by a Bounty Program Manager should start working on this issue to win the bounty.
  • Be sure to follow the guide closely to avoid any delays in payment. Please, allow a few days after your PR has been merged for the bounty to be released.

Good luck, and happy coding! 🎉

Comment From: LisaHusband

Now the bounty assigning comment is appear, and can i be assigned ? 😃