Tile tool sort descending

[mphillips27]

I have financial data group by month and within that month group I need to sort the numbers in descending order. The tile tool would work great using unique value and grouping by month but it sorts the values in ascending order. Can you configure this to sort descending? If not is there a work around to keep the grouping by month and sort the values descending?

[atcodedog05]

Hi @mphillips27 

Why not use sort tool later and sort by descending. Tile tool doesnt have the option.

[atcodedog05]

Hi @mphillips27 

Here is how you can do it.

Workflow:

Hope this helps : )

[mphillips27]

I'm not sure if our tile tool is configured the same because this is not working for me.

output of tile tool -- Tile_num sorts by ascending but I want it sorted descending

Sort tool configuration:

After sort tool:

Something is not the same as yours 

[atcodedog05]

Hi @mphillips27 

Unique column should be month and groupby should be nothing in tile tool.

[mphillips27]

That still does not give me the desire result

output of tile tool

after sort

It sorts the tile sequence but the values were not sorted in the first place so it has no order

[atcodedog05]

Hi @mphillips27 

In sort tool sort by values in instead of seqnum like below.

[atcodedog05]

Hi @mphillips27 

You can try to group together by sorting like this without tile tool.

Hope this helps : )

[mphillips27]

Ok did that and it sorts my value descending but the sequence number is not it is assigned from the tile tool needs to be ascending because I am using it as a rank (highest value should be assigned a rank of 1 and so on), I need the sequence number to be in order ascending.

[atcodedog05 · Accepted solution]

Hi @mphillips27 

Use sort first on month and value and then use tile tool.

Hope this helps : )