rolling 6 weeks value

[#1]

Hi Experts,

i have a chart which has dimension as cyclic group that includes Date, hour, month.

i need to calculate numbers of calls received to the corresponding dimension.

i also need to calculate rolling 6 weeks' average calls received based on date selection.

for example,if the date i have selected is monday, then i need to show last 6 monday's average.

Also, this average should only be enabled if the dimension is chosen as Hour.

How can i do this. Please help me.

[Anonymous]

Defining a Flag at ETL like:

If(weekday(Date)='Mon', 'M',

If(weekday(Date)='Tue', 'T',

and so on..)) as Flag

Then use these Flags value in set expression and something like mentioned in these thread?

Rolling 52 Week Comparison (53-Week Year Problem)

Set Analysis for Rolling Periods

Calculating rolling n-period totals, averages or other aggregations

[#3]

is it possible to do in the table rather than in script?

[vishsaggi]

Do you have a sample app to share which would be easy to work on?

[#5]

i m trying an expression like this

Sum({<date={">=$(=Weekstart(Max(date), -5))<=$(=Date(Max(date)))"}>} Actualcalls)

but i m not getting expected output.

i think there is problem in weekstart.

if i select the date as 'aug 7' i.e., sunday, then it should calculate last 6 sundays and aug 7.

how to do this. please help

[vishsaggi]

= Sum({< date= {"$(= '>=' & Weekstart(Max(date), -5)) and '<=' Date(Max(date)))" } >} Actualcalls)

can you try that ?

[#7]

no Vish, this is not the expected output

[vishsaggi]

Can you share a sample app and expected output please if possible ?