Tile tool sort descending

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?

Common Use Cases

Accepted answers

atcodedog05

Hi @mphillips27

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

Hope this helps : )

tile desc round.yxmd

All comments

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 : )

tile desc round.yxmd

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

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

Hi @mphillips27

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

Hope this helps : )

tile desc round.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703