Metric datatype incorrect when swap dataset about superset HOT 1 OPEN

Hey @rad-pat! I'm here to help you with the issue you've encountered. I'm a bot that can assist you with bug resolution, answer your questions, and guide you on becoming a contributor. Let's dive into solving this together!

To resolve the issue in Superset version 3.1.3 where swapping the dataset of a chart causes a numeric metric to incorrectly convert to text and lose its custom formatting, you can leverage the SHARED_COLUMN_CONFIG_PROPS and DEFAULT_CONFIG_FORM_LAYOUT constants from the superset-frontend/src/explore/components/controls/ColumnConfigControl/constants.tsx file. These constants define the configurable column formatting properties and their default layouts, ensuring that numeric metrics retain their formatting.

Here is how you can ensure the correct formatter is applied:

1. Import the necessary constants:

import { SHARED_COLUMN_CONFIG_PROPS, DEFAULT_CONFIG_FORM_LAYOUT } from 'path-to-constants';

2. Use the SHARED_COLUMN_CONFIG_PROPS to define your column formatting properties:

const columnConfigProps = {
  ...SHARED_COLUMN_CONFIG_PROPS,
  // Add any additional custom properties if needed
};

3. Apply the DEFAULT_CONFIG_FORM_LAYOUT to ensure the correct layout and formatting:

const configFormLayout = {
  ...DEFAULT_CONFIG_FORM_LAYOUT,
  // Customize the layout if necessary
};

4. Ensure the correct formatter is applied to your numeric metrics:

const formatNumericMetric = (metricValue) => {
  const formatter = columnConfigProps.d3NumberFormat;
  return formatter(metricValue);
};

// Example usage
const formattedValue = formatNumericMetric(yourMetricValue);

By using the SHARED_COLUMN_CONFIG_PROPS and DEFAULT_CONFIG_FORM_LAYOUT, you can ensure that numeric metrics retain their custom formatting when swapping datasets, thus resolving the issue ^[1][2].

To continue talking to Dosu, mention @dosu.

from superset.