SORT IN BAR CHART FOR INTERVAL

[manoranjan_d]

HI all

LOAD

[user name],

If(Count([login details])>40, '>40' ,  Replace( Class (Count([login details]),10),'<= x <','-')) as Login

Resident Main

Group By [user name];

in bar chart i have used the login as dimension and count(username) as exprseion

now this dimension has to be in proper sort order of interval form 0 to >4 how to this? i tried but its not working

interval in the  coding

interval in the  coding

[its_anandrjs]

In the sort option >> select expression >> And write expression there for sorting

Ex:-

This is example

=ONLY(Match(FieldName,'0 - 10',

'10 - 20',

'20 - 30',

'30 - 40'

'>50'))

Regards

Anand

[manoranjan_d]

its not working pls share some thing

[its_anandrjs]

Also you can load some sorting table also for the sorting.

Ex:-

Load * Inline

[

[No of times]     ,   [Sort Order]

              0         ,             1

             1-5       ,              2

             6-10     ,              3

            11-20    ,              4

            21-40    ,              5

            >41      ,              6

];

Note:- This  [No of times]  field is connected with your field which is same due to that you get sort order as [Sort Order]

then use this field in the Sorting option to sort.

Regards

Anand

[antoniotiman]

In Sort Option > Expression try

Class (Count([login details]),10)

[manoranjan_d]

SORRY ITS working thanks

[its_anandrjs]

Great

Thanks if got correct answer then please close the thread by appropriate answer.

Regards

Anand