As in screen shot I have data like this after I made some calculations. But what my requirement is in between 02/13/2015 and 02/21/2015 dates have been missed. I want to display '0' where dates have been missed.
like this i want to display.
Pls help me on this.
Date(Date#(Date,'MM/DD/YYYY')) as Date,
Load min(Date) as MinDate, Max(Date) as MaxDate Resident Temp;
Let vMinDate = Num(Peek('MinDate',0,'MinMaxDate'));
Let vMaxDate = Num(Peek('MaxDate',0,'MinMaxDate'));
Drop Table MinMaxDate;
Date($(vMinDate) + IterNo() - 1) as Date
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);
If(IsNull(Value) or Len(Trim(Value))=0, 0, Value) as Value
Order By Date;
Drop Table Temp;