Hi, Question regarding weekno’s and year’s. I have a query which gives
me a few values for some measurement for every day. I included the date.
I now generated a report giving year and week on the x-axis and the
value on the y-. Therefore I used =Year(Date) and Week(Date). The result
on the x axis is this:
46 47 48 49 50 51 1 52
1998 1999
Which ofcourse is not what I want. How can I get the complete week 52
under 1998?
Unless you have data for all weeks, BO can’t display them on chart.
This is similar to Crosstab.
You can insert dummy rows in your table with 0 value for your measures.
– Vasan
-----Original Message-----
From: hans.kingma@UNISOURCE-UCS.COM [SMTP:hans.kingma@UNISOURCE-UCS.COM]
Sent: Thursday, January 07, 1999 2:13 AM
Hi, Question regarding weekno’s and year’s. I have a query which gives
me a few values for some measurement for every day. I included the date.
I now generated a report giving year and week on the x-axis and the
value on the y-. Therefore I used =Year(Date) and Week(Date). The result
on the x axis is this:
46 47 48 49 50 51 1 52
1998 1999
Which ofcourse is not what I want. How can I get the complete week 52
under 1998?