hard code

[manoranjan_d]

how to hardcode the user logged in many times on a range

example

No of times user logged for particular month.

Eg - No of times   No of Users

              0                   100

             1-10                200

             11-20              350

            21-30               40

            31-40               15

            >41                   5

how to achieve this in the script level?

and  these data has to be shown in bar chart as no of times as dimension and no of user as expression?

[its_anandrjs]

Hi,

Then check this attached one with both

1. In the Calculated dimension with class function

2. With Class function in the script level

Main:

LOAD [user name],

     [login details]

FROM

[..\..\Documents\UserData.xlsx]

(ooxml, embedded labels, table is Sheet1);

Query:

LOAD

[user name],

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

Resident Main

Group By [user name];

Regards,

Anand

[manoranjan_d]

we cant achieve these in the calculated dimesnion?