Hi All,
I need to show last 12 weeks data in my bar chart, already i put below expression it showing when there is a data in that week, but even there is no data in that weeks i need to display week number.
How can i resolve it?
=Round((sum({< Datums=,WEEK= {">=$(=MAX(WEEK)-11)"} >} $(sumkm) )/sum({<Datums=,WEEK= {">=$(=MAX(WEEK)-11)"}>} [Kms Travelled])*1000))
Temp:
Load
min(Datums) as minDate,
max(Datums) as maxDate
Resident Master;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
MasterCalendar:
Load
TempDate AS Datums,
Year(TempDate) As Year,
//Week(TempDate) as WEEK,
Date(Monthstart(TempDate), 'MMM-YYYY') as MonthYear,
//week(TempDate) As WEEK,
// Dual(Week(WeekStart(TempDate)) ,
AutoNumber(Week(WeekStart(TempDate)) ) as WEEK1,
Month(TempDate) As Month
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
Thanks in advance
