Random Sorting

[#1]

Dear Community,

again i've got some rather easy looking question which i can't solve.

In a bar chart i want to sort the main dimension "randomly" (e.g.: 2006 2008 2007 2005). How can i use this sorting option?

I tried it with a set analysis, but it doesnt work.

Thanks in advance for any help.

regards

donuteater

[CELAMBARASAN · Accepted solution]

Hi,

     Try with this expression in sort by expression option.

     =match(YearField,'2006','2008','2007','2005')

Celambarasan

[#3]

// solved

This formular works pretty well, but still i've got a problem with some of my calculations.

in some Diagrams with a YearEndEstimate-formula the Dimension is sorted totally weird.

I get results like 'Mae','Jan','Aug'

although i applied the proper sorting via the match() formular.

What does the match formula do?

--

problem was caused by different naming of columns (Mae <> Mrz)

Thanks for you profund help! 🙂

[rbecher]

The match function performs a case sensitive comparison and returns the found position.

BTW, this is not a random sorting because of the literal years-list. If you need a real random sorting just use the random function as sort expression:

=rand()

- Ralf