Forum Discussion
Solved
Sort alphanumeric column by an numeric column
Hi, I have a datatable with air pollution readings. "Wind Dir" is derived from the column "Dirección" (which contains the direction in degrees) by using a "bucket table" / lookup table. Wind...
Hi Anonymous ,
Finally got it to work.
My problem was the added Calculated column X (with the sort order) depended on another Calculated column Y which I wanted to sort by X.
Cheers, Julian
HI jjr333 ,
You need to extract category value from fact table and add index field, then configure 'sort by column' feature on new table category fields and create relationship.
After these steps, You can use custom sort table fields to replace original table column fields.
BTW, I don't think it is possible to custom direction axis for radar chart.
Regards,
Xiaoxin Sheng
Hi Anonymous ,
Finally got it to work.
My problem was the added Calculated column X (with the sort order) depended on another Calculated column Y which I wanted to sort by X.
Cheers, Julian