Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
See the attached sample file.
HTH
Regards
Anand
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
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
Hi,
See the next updated file.
Regards
Anand
hi
pls check the attached one
thanks rohit