Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
is it possible to do in the table rather than in script?
Do you have a sample app to share which would be easy to work on?
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
= Sum({< date= {"$(= '>=' & Weekstart(Max(date), -5)) and '<=' Date(Max(date)))" } >} Actualcalls)
can you try that ?
no Vish, this is not the expected output
Can you share a sample app and expected output please if possible ?