Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try with this expression in sort by expression option.
=match(YearField,'2006','2008','2007','2005')
Celambarasan
Hi,
Try with this expression in sort by expression option.
=match(YearField,'2006','2008','2007','2005')
Celambarasan
// 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! 🙂
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