In the script in a Calendar I created a previous week dimension.
num(Datum) as DateNum,
date(Datum) as Date,
year(Datum) as Year,
month(Datum) as Month,
day(Datum) as Day,
num(month(Datum) ) as MonthNum,
Weekday(Datum, 0) as Weekday,
floor(monthstart(Datum)) as YearMonthStartNum,
week(Datum) as Weeknr,
week(now())-1 as PreviousWeeknr
In the app the previous weeknummer is showing correctly but the measure isn't.
The measure is just a very simple sum of answered calls: sum(Answered)
Although the previous weeknumber is showing correctly, the measure is showing the complete total for all weeks and all years and not only the sum for the previous week. I also tried week(Today())-1 but it didn't work either
I'm not having this problem with Month, Year, Weekday...
Does anyone can advice me on this?
Solved! Go to Solution.
solved by adding some new code:
week(Datum)-1 as PreviousWeekNew
where CheckFlagPreviousWeek = 1;
if(week(Datum) = week(today())-1,1,0) as CheckFlagPreviousWeek;
Thanks for your suppport.
In the Calendar (script) I created the following dimensions:
Weekstart(Datum) as WeekStart,
Weekstart(now())-7 as PreviousWeekStart
But as you can see, the dimension is also returning the total sum of all calls for all months and all years and not only for the last week.
Previous WeekStart should be
date(Weekstart(Datum) -7) as PreviousWeekStart
Also share Sample app if possible. There might be some issue with linking data to calender