Chart's table sort by doesn't work

[NinjaDev06]

How to reproduce the bug

Create a chart with the configuration as the screenshot.

Expected results

I expect to be able to order the column 'metric' display in the table.

Actual results

I tried a lot of configuration and nothing seem to change the order in the table.

Screenshots

The metric is on the column 'value'. I set the title to a space to remove it from the chart's table.

Environment

(please complete the following information):

• browser type and version: Chrome version 94.0.4606.61 64-bit
• superset version: 1.2.0
• python version: ?
• node.js version: ?
• any feature flags active: ?

Additional context

Here an example of the dataset I used connect to a Sql view.

| metric       | day      | value  | other columns
| population | 2021-10-11  | 12      | ...
| population | 2021-10-11  | 45      | ...
| completed | 2021-10-11  | 5      | ...
| population | 2021-10-12  | 98      | ...
| completed | 2021-10-11  | 6      | ...
| completed | 2021-10-12  | 2      | ...
...

I can change the Sql view or create another one as a solution.