topic Re: Sort a column by another column principle in Custom Visuals Development Discussion

Sort a column by another column principle

Anonymous — Fri, 03 May 2024 10:53:58 GMT

Hi everyone, I have a table like this

I would to visual a table with Parent_Index and Index as Column Label like this

I want to sort weekday in order so I create the Order_id columns, but I can not sort Index Column by Order_id columns

I just do not really understand why I am wrong and how to done it.

I will be appreciated for your help. Thanks in advance!

Re: Sort a column by another column principle

lbendlin — Sat, 04 May 2024 00:26:15 GMT

Add a composite key (Index+parent index) and change the order_id column to consecutive numbers across that composite key as needed.

Re: Sort a column by another column principle

Anonymous — Mon, 06 May 2024 05:08:36 GMT

But when it comes for visualizing, I still want to use column "Index" and "Parent_Index" seperately for visual's column labels. Creating composite key and sorting it by distinct consecutive order_id seem not really help.

Re: Sort a column by another column principle

lbendlin — Mon, 06 May 2024 11:07:10 GMT

You can still do that. Try in out.

Re: Sort a column by another column principle

Anonymous — Thu, 09 May 2024 07:39:02 GMT

It worked!! So sorry for late response.
Thank you very much.