Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Display zero values
Migrateduser
Hi I am working on report which will display the count for 8 quarters. When I am creating data set I am getting the count for the records that are available. The results are as follows.
QUARTER_START_DATE CNT
---
Oct-11 1
Jul-12 34
Oct-12 3
Jul-13 1
I am using the following query:
SELECT
TO_CHAR((TRUNC ("TARGET-DEPLOYMENT-DATE",'Q')+93),'MM-YYYY') AS quarter_start_date ,COUNT (ASSETURN) AS cnt
FROM ERRUSER.RPT_CLASSIFIERS_36
WHERE
"TARGET-DEPLOYMENT-DATE" >= ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -9 )
AND "TARGET-DEPLOYMENT-DATE" < ADD_MONTHS ( TRUNC (SYSDATE, 'Q'),15)
GROUP BY (TRUNC ("TARGET-DEPLOYMENT-DATE" ,'Q'))
ORDER BY TRUNC ("TARGET-DEPLOYMENT-DATE" , 'Q')
Can u suggest me how can I achieve the following result:
QUARTER_START_DATE CNT
---
Q3 - 2011 0
Q4 - 2011 1
Q1 - 2012 0
Q2 - 2012 34
Q3 - 2012 0
Q4 - 2012 3
Q1 - 2013 0
Q2 - 2013 1
Thanks in advance,
AR
Find more posts tagged with
Comments
There are no comments yet