Forum Discussion
ArchStanton
Power Participant
Power ParticipantDate Bandings require sorting in visual
Hi, I have various date bands ranging from 0-3mths, 3-6 and so on all the way up to 12 mths +. These are not sorted when I add them to the Y axis in my visual so I was thinking of ranking them 1...
Hi ArchStanton ，
Pls test the below:
RANK = IF ( [Age Profile Creation Months] = "0-3 Months", 1, IF ( [Age Profile Creation Months] = "3-6 Months", 2, IF ( [Age Profile Creation Months] = "6-9 Months", 3, IF ( [Age Profile Creation Months] = "9-12 Months", 4, IF ( [Age Profile Creation Months] = "12+ Months", 5,BLANK() ) ) ) ) )Return:
Best Regards
Lucien
johnt75
Super User
Super Userthat's still a string, you need to return the number 6 without the quotes
ArchStantonPower Participant
Power Participant
I've tried lots of variations and the error just keeps appearing:
- johnt75
the switch statement should not have any = signs in it. the first argument should be the column name, then a list of pairs of values separated by commas, see my original post for the template.
- ArchStanton
Thanks, I managed to get it to work but its only given my 5's and 6's for some reason?
In the meantime I've copied the original Date Banding Column - modified it by substituting Date Bands for No's 1-5 and then applied a Sort on the column and this seems to have done the trick. I'd still like to know why the SWITCH code is ignoring 1,2,3,4 though?
- ArchStanton