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