Line Chart

[#1]

Hello Everyone,

I want to make a multiple line chart. I have the data structured in the following way for 5 channels for 8 months:

Channel_1_Month_1_Sales
Channel_2_Month_1_Sales
Channel_3_Month_1_Sales

Channel_1_Month_2_Sales
Channel_2_Month_2_Sales
Channel_3_Month_2_Sales

Channel_1_Month_3_Sales
Channel_2_Month_3_Sales
Channel_3_Month_3_Sales

.
.
.
.

I would like to plot this in the form of a line chart so that the user can see the trend monthwise for each channel...screenshot attached (done in excel)

Any ideas?

Thanks

[its_anandrjs]

Hi,

Yes it is possible put Channel in X-axis  and months in Y-axis and set the chart as type line chart and it will created as you discribe.

HTH

Regards

Anand

[its_anandrjs]

Hi,

See the attached sample file.

HTH

Regards

Anand

[#4]

Hi Anand,

Thank you for your response.

What i was looking for is different. I have the data in the structure i have mentioned, i do not have separate variables for channels and months.

Any thoughts?

Thanks

[its_anandrjs]

Hi,

See the attached sample file.

Ok i understood you want to create with this type of data

Channel_1_Month_1_Sales
Channel_2_Month_1_Sales
Channel_3_Month_1_Sales

Channel_1_Month_2_Sales
Channel_2_Month_2_Sales
Channel_3_Month_2_Sales

Channel_1_Month_3_Sales
Channel_2_Month_3_Sales
Channel_3_Month_3_Sales

but there is no value to show so i do one thing add a Value column and create a chart by this code

Temp:

LOAD * INLINE

[

Data                   ,Value

Channel_1_Month_1_Sales,100

Channel_2_Month_1_Sales,400

Channel_3_Month_1_Sales,700

Channel_1_Month_2_Sales,200

Channel_2_Month_2_Sales,500

Channel_3_Month_2_Sales,800

Channel_1_Month_3_Sales,300

Channel_2_Month_3_Sales,600

Channel_3_Month_3_Sales,900

];

Load

*,

Left(Data,9)  as Channels,

Mid(Data,11,7) as Months

Resident Temp;

Drop table Temp;

By the Left and Mid we need to fetch the fields and create two fields.

Let me know about this

HTH

Regards

Anand

[its_anandrjs]

Hi,

See the next updated file.

Regards

Anand

[rohit214]

hi

pls check the attached one

thanks rohit