GitHub user mcwleong added a comment to the discussion: Cannot sort X-Axis on a bar chart if X-axis is a var_string (MySQL)
I've found a workaround. Under "Computed Column" of the dataset, create a new computed column with SQL Expression = your_varchar_col_name. Set the column data type to String. Use this computed column as x-axis of your bar chart. Superset will then allow you to sort the x axis using metrics. This come with an extra benefit on allowing you to set your_varchar_col_name as dimension, which enables cross filtering in the dashboard. GitHub link: https://github.com/apache/superset/discussions/29271#discussioncomment-15316904 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
