Line chart help???

[amit_saini]

Folks,

I want to create a line Graph , below are the requirements:

X-Axis
Dec-14 to Dec-15
YTD-15

Y-Axis
0 % - 100 %

Data
% ECO Due of Active ECOs --> For this I do have expression so I can use it
YTD-15
Target % ECO Due of Active ECOs --> Target need to be set as 25% , can do  by using reference lines

Kindly help here.

Thanks,

AS

[#2]

Hi,

Under the Axes tab, in scale, Check Static Min, Static Max, Static Step and give values 0.0,1,0.25 respectively..

For Y axis..

Hope it helps,

[amit_saini]

Pratik,

Thanks for the response , I'm just looking for the solution of

X-Axis

Dec-14 to Dec-15

Rest already has been done.

Thanks,

AS

[#4]

ok,

If you have the right dimension in X-axis,

You can go to sort tab, Under it Check the expression checkbox write expr:

=Match(YourMonthName,'Dec-14','Jan-15','Feb-15','Mar-15','Apr-15','May-15','Jun-15','Jul-15','Aug-15','Sep-15','Oct-15','Nov-15','Dec-15')
Hope it works.

[Anonymous]

Amit,

You should first check you are loading your data field into the right format, because your Data_Key% field is text format, and should be date or timestamp format. Use Date() function in script to load it properly.

Your Month field is empty. Use MonthName() function on your date field to load it properly.

Once it is done you can go ahead with your chart.

If after this you are still in trouble, please share a qvw again with this changes. Be sure to load more than one date in sample data in order to test your monthly chart.

Marc.