Straight Table - Custom Sort Order

[johnjustus]

Hi All,

I have a sorting question in the straight table.

The data is like this in the straight table.

Name                                                  Owner

# of Dealing Authorities                       Keen

# of Compliants                                   Keen

# of Breaks                                          Lobato

# of  Lates                                             John

# of  Calls                                           Lobato

# of   Incoming                                   John

# of   Outgoing                                    Keen

I want to the table to be sorted as below

Name                                                  Owner

# of Dealing Authorities                       Keen

# of  Outgoing                                     Keen

# of Compliants                                   Keen

# of Breaks                                          Lobato

# of  Calls                                           Lobato

# of   Incoming                                   John

# of  Lates                                           John

Is the above possible? Is there an Custom Sort Order available on the Name column?

Thanks

[sunny_talwar]

Sure, you can use Match function

Match(Name, '# of Dealing Authorities', '# of  Outgoing', '# of Compliants', '# of Breaks', '# of  Calls', '# of   Incoming', '# of  Lates')

[johnjustus]

Thanks

I tried like this and did not work

Straight table Chart Properties -> Sort -> Columns -> Name -> Sort by Expression

If(Match(Name, '# of Dealing Authorities', '# of  Outgoing', '# of Compliants', '# of Breaks', '# of  Calls', '# of   Incoming', '# of  Lates'),Name)

Am I doing anything wrong?

Thanks

[sunny_talwar · Accepted solution]

You just need this...

Match(Name, '# of Dealing Authorities', '# of  Outgoing', '# of Compliants', '# of Breaks', '# of  Calls', '# of   Incoming', '# of  Lates')

If is not needed

[johnjustus]

Yes, I realized that.

That's a good solution. Thanks

[ziadm]

Hi use Dual and Mapping

MapNameSort:

Mapping

LOAD * Inline [

Name,Order

# of Dealing Authorities,1

# of Outgoing,2

# of Compliants,3

# of Breaks,4

# of Calls,5

# of Incoming,6

# of Lates,  7

];

Table1:

load Dual(Name,ApplyMap('MapNameSort',Name)) as Name,

Owner;

load * Inline [

Name,                                                  Owner

# of Dealing Authorities,                       Keen

# of Compliants,                                   Keen

# of Breaks,                                          Lobato

# of Lates,                                             John

# of Calls,                                           Lobato

# of Incoming,                                   John

# of Outgoing,                                    Keen ];

after that sort by the Name in Ascending order in your chart or Table

[Robertmccarthy2]

what if "is" is needed? 

[Robertmccarthy2]

What if "is" is needed?