Line chart issue

[#1]

hi,

i was supposed to plot a Line chart with weekday dimension in x-axis for whole month and trend it should be like across whole year, managed to plot the weekdays but it is scrolling for whole year as shown in below screen shot but i want to plot this for 5 weeks which should look like as below. please help me out on this.

[MarcoWedel]

maybe like this:

hope this helps

regards

Marco

[#3]

hi Marco,

I got the advanced editor now, thanks for the suggestion, attached the sample data and qvw file.

we want weekdays (mon,Tue...) on the x-axis for 31 days it should be like monthly trend for whole year. in sample data attached has data for whole one year.

it has to be like below screenshot.

kindly help me on this.

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be to add a dual field that represents the sequence of weekdays during a month:

Calendar:

LOAD *,

    Dual(WEEK_DAY,WEEK_DAY+7*(WeekMonth-1)) as WeekDayMonth;

LOAD *,

    Day(Date) as DAY,

    Month(Date) as MONTH,

    date(monthstart(Date), 'MMM-YYYY') as MONTH_YEAR,

    Year(Date) as YEAR,

    WeekDay(Date) as WEEK_DAY,

    Week(Date) as WEEK_NO,

    WeekName(Date) as WEEK_NAME,

    AutoNumber(WeekName(Date),MonthName(Date)) as WeekMonth,

    Week(weekstart(Date)) & '-' & WeekYear(Date) as WEEK_YEAR,

    WeekStart(Date) as WEEK_START_YEAR,

    QuarterName(Date) as QUARTER_DETAILS,

    'Q' & Ceil(Month(Date)/3) as QUARTER;

LOAD  

    date(makedate(2016-01-01)+recno()-1,'DD-MM-YYYY') as Date  

    autogenerate 5000;  // No Of Days In A Year //

hope this helps

regards

Marco

[#5]

hi Marco,

thanks for your tremendous support, this is exactly as per my requirement and No words you are absolutely genius.

Regards,
Pradeep.

[MarcoWedel]

Thanks

Glad you liked it.

Marco

[MarcoWedel]

another possibility to calculate the "WeekDayMonth" values as calculated dimension:

=Dual(WeekDay(Date),Day(Date)+WeekDay(MonthStart(Date))-1)

maybe also helpful

regards

Marco