Managing Reports › Example Ad Hoc Reports › Example: View All Open Requests that Do Not Include a Status of Work In Progress
Example: View All Open Requests that Do Not Include a Status of Work In Progress
In this example, you specify the Count reporting function to return the total number of open requests.
Example: View all open requests that do not have a status of work in progress
- Click New, Web Intelligence Document from the menu bar.
The New Web Intelligence Document page appears.
- Select the CA SDM universe in the Universe column.
The Web Intelligence document appears along with the universe information in the left pane.
Note: To improve navigation, close the Attached Service Type folder in the left pane.
- Locate and then expand the Request, Request Detail folders in the left pane. (Use the scroll bar to navigate folders.)
- Select each of the following objects, then drag and drop them from the left pane to the top right pane under Results Objects.
- Status Symbol
- Ref Num
- Summary
- Select the Status Symbol object, then drag and drop it to the bottom right panel under Query Filters. Close the Request Detail folder.
- Expand the Request Filters folder, then drag and drop the Active filter to the bottom right panel under Query Filters.
- In the Query Filters pane, click the In list arrow on the Status Symbol object, and select the Not Equal to operator.
- Select Work in Progress from the Operand Type menu.
- Click Edit Report on the main toolbar.
The Report Viewer opens.
- In the report, select the Ref Num column. This action enables the Insert Sum command on the Reporting toolbar.
- Click the Insert Sum command, then select Count from the menu.
- In the report, right-click the =[Status Symbol] cell, then select Set as Section from the context menu.
- Click Refresh Data on the main toolbar to run the report.
- Click Save.
The report displays the total number (count) of requests that do not have a status of Work in Progress.
Copyright © 2013 CA.
All rights reserved.
|
|