There is a requirement for creation of chart portlet in our application. The chart portlet should display the project timesheets status for a particular time period to his project manager. That means the project manager should see for particular time period how many timesheets are in submitted, approved or posted status for a project by the resources . Also how many hours has been submitted.
So this has to be created as bars graph. The attached screenshot can give more info.
The NSQL query has been created, but the portlet does not show data as required.
Can you anyone help me in this?