Text Facet (not alphabetical order)

Support and Helpdesk
7

If you want a (very hacky) way of doing this right now, you can sort of do it by creating a custom text facet with a "cross" expression

So if I have a project called "Alphabet" that contains one column "Letters"

Letters
B
A
B
B
A
A
B
D
C

Then you can create a custom text facet on the letters column with and expression like:

value.cross("Alphabet","Letters")[0].index.toString("%04d")+" "+value

This will create a facet with values:

0000 B           4
0001 A           3
0007 D           1
0008 C           1

This is using the row.index from the first occurrence of the value in the column (found by the cross expression) with a bit of formatting to make sure "2" sorts before "10" etc.

Does that help?

1 Like