May be something like this?
=If(Message <= 600, '0-600',
If(Message <= 800, '600-800',
If(Message <= 1000, '800-1000',
If(Message <= 1500, '1000-1500', '>1500'))))
Dimension 2: Location
Community_176823.qvw 148.5 K
Its working for the sample data provided by me.BUt in actual i am getting the data from 3 data sources and concatenating them where i am giving alias name for the header related to Message in the 3 data sources as 'Messages'.in that case this code does not seem to work.Attaching the QVW for your reference. !