Oracle Graphics Builder 6 - Line chart using week and year data
I have a situation like this:
I want to create a line chart that shows week in x-axis and price in y-axis. Subcategory is customer. Everything goes fine if i look at data for only one year. But if i make a select that returns weeks for years 2002 and 2003, the graph doesn't work right. Graphics doesn't seem to understand that year changes, it draws a line to the beginning of the weeks. Datatype of x-axis is continuos.