Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
As you can see above, there are missing values. but I would like to present all the dates in there so that I can observe time based progression.
There are no missing date values in the table and even though the count is Null the date is taking up one row since I used this code in script.
QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
Temp:
Load
min([Complete Date]) as minDate,
max([Complete Date]) as maxDate
Resident Tasks;
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 [Complete Date],
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day(TempDate) As Day,
//Hour(TempDate) As Hour,
// Minute(TempDate) As Minute,
// Second(TempDate) As Second,
ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
--------------------------------------------------------------------------------------------------------------------------
I have used the same data for both table and chart. and in table I see all the dates.
as you can see, even though values are missing it is still taking up a row for every date.
I want the same with my chart.
Please help!! Thank you!!
Have you unchecked 'Suppress Zero-Values' and 'Suppress Missing' on the presentation tab?
Have you unchecked 'Suppress Zero-Values' and 'Suppress Missing' on the presentation tab?
Thank you Sunny!
you are amazing....
Can you send us a sample qvw file for a quick look if possible ?
Did you uncheck (highlighted in Yellow in the bottom) this and tried ?
vishsaggi thank you! this is exactly the way sunny answered it and it worked!