Hi Everyone,
I have two charts, the left one is supposed to provide the "Week Of" value to refresh the right one.
When I click on a bar, I want to get the value of the x-axis (the date) to fill into the "Week Of" item. This line in my query gives me the date value of WEEK_OF.
TO_CHAR(TRUNC(REC_TIME, 'IW'), 'YYYY-MM-DD') AS WEEK_OF
The following is how I get the value and put it into the item.
javascript:$s('P11_WEEKOF_1',&WEEK_OF.);
Instead of the date, I get a seemly random 4 digit number like below.
If I try this with the value of the blue bar which is approximately 1.25 million, it works fine. Any idea why this is happening and how I could fix it? Why cant I get the x-axis label value.