Display set of weeks on x axis

[#1]

Hey techies,

I am trying to display a set of last 26 weeks on x axis irrespective of its values, but if i take largest 26 weeks in dimension limits it takes weeks largest based on values, can someone please suggest me how to overcome this issue,

thanks.

[salto]

Hello,

Maybe you should try ordering the Week  dimension in the chart, by ascending numeric values (in the "Ordering" tab of the chart).

Hope this helps.

[#3]

Thanks for you quick reply, bu i have tried this option too but its not working,

i have written expression as

Sum({$<Week = {">=$(=vMinWeek)<=$(=vMaxWeek)"}>} Qty),''),

where vMaxWeek is max(Week)  and vMinWeek is "max(week) -26"

which is not working.

[sundarakumar]

can u post some sample data or app???

[salto]

Hello,

if the week is a dimension in your data model, maybe the solution is easier.

Set the dimension to Week and set the expression to sum (Qty)

Does this make any sense?

[#6]

Hi Aasif,

Assuming that you are using Week as the dimension then maybe you could try

Sum({<Week = {">=$(=max(Week)-25)<=$(=max(Week))"}>} Qty)

Hope this helps.

Cheers,

Tyler

[jagan]

Hi Aasif,

Try like this

Use your week as dimension and use the following as expression, if you have any date dimension in your data model

=Sum({<MonthDimensionName=, WeekDimensionName=, YearDimensionName=, QuarterDimensionName=, DateDimensionName = {'>=$(=WeekStart(Max(DateDimensionName), -25))<=$(=WeekEnd(Max(DateDimensionName)))'}>} MeasureName)

Here we are controlling the dimensional values with the expression, always you will get the last 26 weeks.

Regards,

Jagan.

[#8]

Hi,

attached here is sample file,

I need to display last 26 weeks starting from week(201313) to (201348).

week must be in sorted ascending numeric and all 26 weeks should me displayed

thanks and regards.

[salto]

Is this what you are looking for? Note that the scrollbar appears:

[#10]

Hi Aasif,

Please find attached, there aren't 26 values in the chart since it looks like you don't have values for some of the weeks, if you want to get the last 26 weekly values then you would probably be best served doing that in your script.

Cheers,

Tyler