Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Sure, you can use Match function
Match(Name, '# of Dealing Authorities', '# of Outgoing', '# of Compliants', '# of Breaks', '# of Calls', '# of Incoming', '# of Lates')
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
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
Yes, I realized that.
That's a good solution. Thanks
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
what if "is" is needed?