Notice your custom field is being treated as a metric:
How to notice: Field is blue, and the aggregation function is displayed in the left (=SUM).
This way, the individual numbers of this are being summarized before sorting. In short, to solve your problem, you need to make this field be green (so it is treated as a dimension).
Since I don't have access to your dashboard, I listed some options you may try to follow:
- Try to select the field again to check if it appear as green as an option. If so, just select it and you're done;
- If you created the custom field as a metric instead of a field, try to delete it and create again using the proper type (there's no way to change type, as far as I can tell). Then, go to (1);
- If none of these options work for you, try to add the field as a dimension in the table. This way it will be displayed in the table (I don't know if this bothers you), but this way it doesn't matter if the sort field is a field or metric (green or blue) because it will be treated as a dimension in the table.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…