Split Rows

[sat_tok52]

Hi All ,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

Regards,

Satish

Hi All,

I Have a column called ID it contains 100 rows.As per my Requirement my line chart to show the range of 0-30  rows 1Datapoint  and 30-60 2Datepoint and 60-90 3Datapoint because we considering each 30 rows one datapoint ,and also rest of 10 rows i don't want to show in my chart.

ID	%Value
0-30	63.00%
30-60	75.35%
60-90	85.55%

I am using Class function like Class(ID,30) but it is displaying last last 10 rows percentage also.

Regards,
Satish

[MK_QSL]

Go to your Expression Tab

and use something like similar

COUNT({<ID = {"<=90"}>}FieldName)

Or Change your Calculated Dimension as below

=CLASS(IF(ID<=90,ID), 30)

Tick Suppress When Value is Null

Edit : Changed 90 instead of 60 to get data upto ID 90

[mrossoit]

Try this

Regards

MR

[sat_tok52]

Hi Rosso,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

[sat_tok52]

Hi Manish,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

Regards,

Satish

[mrossoit]

Try to define your ID classes in the script and use that new field as dimension of your chart.

MR

[sat_tok52]

Hi Manish,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

Regards,
Satish

[sat_tok52]

Hi Rosso,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

[mrossoit]

Try it now.

[Anonymous]

can you share your QVW.