Hello Gurus,
I need some help regarding Quarterly Data filtering logic in Cognos 10.2.2
This is Chart report which will display Quarterly trend data..
I have [DAILY DATE] coloumn from DB
Created data item as [Month to Quarter]
(case
when cast(extract(month,[DAILYDATE]),varchar(4)) in ('1','2','3') then 'Q1'
..so on 'Q4'
end)}
calculating 'Percentage' based on
case
when [Month to Quarter] ='Q1' and cast(extract(month,[DAILYDATE]),varchar(4)) in ('1','2','3') then
(total([Percentage of Daily Count] for [Month to Quarter])/3)...so on 'Q4'
else 0
end
Now if any Month data within any Quarter is missed then that Percenatge of that whole Quarter should display zero.
Please let me know if you need any further information on this.
Thanks in Advance
You'll need an outer join. The outer query will contain all of the time periods you want to appear. The inner side will have the data to link with those time periods.