Split Rows

[sat_tok52]

Thanks All,

Actually my requirement is we calculating %lean value by using line chart.We have 3000 records in our measure Column. Instead of Showing 3000 record in  x-axis.We are Merge 30 records one Data Point and Next 30 records one Data point etc....

Please see the Attached Screen Show X-axis have numerical values each numerical value contains 30 records

[#2]

Hi Sateesh,

not really sure of your required output, can you knock up an example and post, would be easier to help then

Joe

[Roop]

If this is your data .....

data:

LOAD * INLINE [

PRODUCT, YEAR, SALES

1, 2013, 12

2, 2013,  300

3, 2013,  400

4, 2013,  500

5, 2013,  600

6, 2013,  600

7, 2014,  500

8, 2014,  400

9, 2014,  300

4, 2014,  200

5, 2014,  100

9, 2014,  900

];

Use some kind of syntax like this to create the N records that you require. You can obviously change the first statement to include the RecNo() statement also.

load PRODUCT as PROD,

  YEAR as YR,

  SALES as SLS

Resident data

where RecNo() < 5

;

[sat_tok52]

Thanks All,

Actually my requirement is we calculating %lean value by using line chart.We have 3000 records in our measure Column. Instead of Showing 3000 record in  x-axis.We are Merge 30 records one Data Point and Next 30 records one Data point etc....

[sat_tok52]

Thanks All,

Actually my requirement is we calculating %lean value by using line chart.We have 3000 records in our measure Column. Instead of Showing 3000 record in  x-axis.We are Merge 30 records one Data Point and Next 30 records one Data point etc....

[sibideepak]

Hi Sateesh,

According to your requirement ,how do you want to name every 30 records which isn't meaningless acutually,

Else you can create like Range in the Dimension and use your measure.

Can you post your sample data ?

[Roop]

Probably use IntervalMatch in some form .... Keep the record number when you load the data and generate a small table that will create an intervalmatch input of 1 to 30, 31 to 60 etc.

[#8]

You can use the Class function in a Calculate Dimension like:

=Class(RowId_Num,5)

where RowId_Num matches RowNo() of records.

You can create your RowId_Num during data load.