Hello,
I was wondering about how you support custo...
# gooddata-cna
Alex Kearns
01/31/2022, 5:36 PMHello,
I was wondering about how you support custom sorting order for Good Data CN. Does it need to be an integer, or can it be a decimal?
j
Jan Soubusta
02/01/2022, 7:54 AMHi Alexandra,
where exactly do you expect this custom sorting? In Analytical designer?
Jan Soubusta
02/01/2022, 7:56 AMimage.png
Jan Soubusta
02/01/2022, 7:57 AMI can sort by Region(string) as well as by Sum of Quantity(decimal).
If I map a fact to a table column of INT data type, create a report summing up such a fact, I can sort by it too.
a
Alex Kearns
02/03/2022, 11:27 PMThanks @Jan Soubusta
I am wanting to provide a custom sort order in my logical data model, so that I can sort something like "Ratings" (which would be a text column) by that sort order as opposed to alphabetical. In the SaaS model you can do that in the LDM.
j
Jan Soubusta
02/04/2022, 10:39 AMAFAIK it is planned into the next release (1.7, March), right, @Ondrej Macek?
o
Ondrej Macek
02/04/2022, 12:27 PMYes, we are working on it. I believe it will be available soon - in the next release or in the following one.
a
Alex Kearns
02/04/2022, 5:20 PMOh awesome, that's great to hear!
Alex Kearns
02/04/2022, 5:24 PMIs it required that the sorting column be an integer? or can it be decimal?
j
Jan Soubusta
02/06/2022, 9:53 AMGenerally you will be able to define sort label for a attribute.
By default decimal columns are generated as facts in LDM.
But you can manually change it and map decimal column to label and then, with the upcoming feature, set this label as sort label.
AFAIK setting facts as sort columns is not supported and it is not on our road map, right, @Ondrej Macek?