interval in the coding

[manoranjan_d]

hi all,

i need the interval like below

No of times user logged.

Eg - No of times   No of Users

              0                   10

             1-5                  20

             6-10                30

            11-20               40

            21-40               15

            >41                   5

i tried

LOAD

[user name],

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

Resident Main

Group By [user name];

but its not good its howing more interval i need the example interval till >41 is fine. how to do this?

[Gysbert_Wassenaar]

Perhaps like this:

LOAD

[user name],

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

Resident Main

Group By [user name];

[Aurelien_Martinez]

Hi,

You can use Intervalmatch function.

LOAD

[user name],

Count([login details]) as LoginCount

Resident Main

Group By [user name];

_temp:

Load * Inline [

  interName, Min, Max

0, 0, 0

1-5, 1, 5

];

intervalmatch(LoginCount)

Load

Min

Max

resident _temp

;

[manoranjan_d]

hi gysbert  now i want to sort this interval in the bar chart? how to do this?

example:

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

now this dimension has to be in proper sort orderof interval form 0 to >40

[Gysbert_Wassenaar]

Change the line to:

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

That way you can sort Login numerically