Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
please attach some sample
Hi,
Check this links, hope it helps you.
Set Analysis for Rolling Periods
Set Analysis for certain Point in Time
Regards,
jagan.
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
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
i need last four. but it's not there.
Sum({<Week={'>=$(=Max(Week)-4) <=$(=Max(Week))'}>}Data)
PFA
Hi,
Check the chages in my post now.