Show last four values in bar chart

[anuradhaa]

I have bar chart with week number in x-axis.

I want to show last for weeks data. so how can i have that under dimension limits. it doesn't have last.

Thank You

[vikasmahajan]

please attach some sample

[jagan]

Hi,

Check this links, hope it helps you.

Set Analysis for Rolling Periods

Set Analysis for certain Point in Time

Regards,

jagan.

[HirisH_V7]

Hi,

By this you can have a week view for last four weeks,

At Backend , In Your calendar pick your Date as,

Week(Date) as Week,

There by You an use this in the front end as dimension and you can pick largest or Smallest or First four in Dimension limits,

Or else in your Expression Your can write like this,

Sum( {<Date={">=$(=WeekStart(Max(Date), -3))<=$(=WeekStart(Max(Date)))"}>}Sales)

Hope this Helps,

PFA,

Regards,

HirisH

[anuradhaa]

no, i have data based on weeks. i want to know how to display latest 4 weeks.

say i have 20 weeks, as 1-20 in x-axsis and i want to show week#16-week#20 only

[anuradhaa]

i need last four. but it's not there.

[tresesco · Accepted solution]

Sum({<Week={'>=$(=Max(Week)-4) <=$(=Max(Week))'}>}Data)

PFA

[HirisH_V7]

Hi,

Check the chages in my post now.