Hello,
I would like to do a custom sort on a quick filter. Currently I have attempted to concantenate a number and name in a calculated field. However since this is treated as text the sort does not work as anticipated.
Example of current sorting Desired Result
1 Location 1 1 Location 1
12 Location 12 2 Location 2
13 Location 13 12 Location 12
2 Location 2 13 Location 13
22 Location 22 22 Location 22
23 Location 23 23 Location 23
I am very new to Domo and any help would be greatly appreciated.