If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Missing values in line chart

Started by Sunita, 27 Jul 2010 10:04:36 AM

Previous topic - Next topic

Sunita

Hi All,

I am trying to build a line chart on summary of my list report.

my list report similar to the below report

Name    Week1    Week2   Week3
abc        5            0         1
def         2            0         3
-----------------------------
Totals     7             0         4

Now i am building a line chart with x axis as weeks and Y axis as totals. Issue that i am facing right now is, in x-axis i am getting weeks for which i have some data, cognos is removing week2 from x-axis as it has zero value.
Is there a way to get all weeks in x-axis even if Totals is zero for that week.
I do not have a direct field as weeks, i am calculating it from date and day field present in my namespace

Thanks