Forum Discussion
Sort column by value
Hello,
i want to sort my column partner_display by ecart_max
when i try to do it by sorting i got this message :
How can i sort my column by value ?
Reagrds,
Sophie
Hi Sophie_
In the Query Editor (Transform data) go to your table and choose reference.
Then highlight the two columns to keep and choose remove other columns. Then choose Remove duplicates
Join this back onto your table in the front end and use this column instead of the original.
3 Replies
Hi Sophie_
Could you split these two columns into a seperate table.
Remove duplicates and then apply your sort.Then join back to your original visual. That would remove the error as the seperate table is unique.
If you are using a chart visual, it is possibel to sort using a measure.
Create a measure that returns the MAX ID and put it in the tooltip. On the visual apply a sort.
For anyone interested:
“Sort by another column. We cannot sort the column ‘partner_display’ by ‘ecart_max’. You cannot have multiple values in ‘ecart_max’ for the same value in ‘partner_display’. Choose another column to sort or update the data in ‘ecart_max’Hello SamWiseOwl ,
do you have an exemple to di this : "
Remove duplicates and then apply your sort.
Then join back to your original visual. That would remove the error as the seperate table is unique." ?
I want to sort partner_display in filter.
Sophie
Hi Sophie_
In the Query Editor (Transform data) go to your table and choose reference.
Then highlight the two columns to keep and choose remove other columns. Then choose Remove duplicates
Join this back onto your table in the front end and use this column instead of the original.
