hi
I could not group by date to get average values for the week
I am trying to generate chart for the following query

select trunc( txn_dt, 'IW') week, avg(point_total) from average_points group by trunc(txn_dt, 'IW')

I managed to get the avg(point_total) in Y axis, but I could not get the txn_dt grouped by week in the X axis

could you please give suggestions that I can do using InfoAssist or InfoStudio

This message has been edited. Last edited by: <Kathryn Henning>,

Ramkumar,

Please post your focus code for what you have tried so far.

thanks!