Hi,
I have a table with these fields:
date_assigned;
wr_id (work request);
priority;
The priority field has values from 0 to 5, which means that the wr_id must assume a priority level and a date_assigned to that work request. So I can have several wr_id's with different priorities, and different date_assigned's.
This means that the chart (if it's a line one) will have 5 lines, each one representing the priority numbers.
In the x axis i need to put a date interval - month/year - (always a year apart) that changes based on the values inserted by the user.
In the y axis of the chart I need the values of the wr_id's total.
I would be grateful if someone could help me with this issue.
Jaime
I have a table with these fields:
date_assigned;
wr_id (work request);
priority;
The priority field has values from 0 to 5, which means that the wr_id must assume a priority level and a date_assigned to that work request. So I can have several wr_id's with different priorities, and different date_assigned's.
This means that the chart (if it's a line one) will have 5 lines, each one representing the priority numbers.
In the x axis i need to put a date interval - month/year - (always a year apart) that changes based on the values inserted by the user.
In the y axis of the chart I need the values of the wr_id's total.
I would be grateful if someone could help me with this issue.
Jaime