How to add a simple pie chart to a report Track-It! 2019 and later

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'
Support IDs for BMC Customer Support Site Guest User
Profiles Which Include    Back to All Support IDs
 

Knowledge Article

How to add a simple pie chart to a report Track-It! 2019 and later
How to add a simple pie chart to a report Track-It! 2019 and later
Track-It!
Track-It!
Track-It! 2019 and later
Track-It!
Track-It!
Track-It! 2019 and later
How can I add a simple pie chart to a report in Track-It! 2019 and later version of Track-It!?
Steps to insert Graph in Report (example: Closed Tickets by Technician with Bar Graph)
Steps to insert Graph in Report (example: Closed Tickets by Technician with Bar Graph)
 
  1. Copy existing report “Closed Tickets by Technician” call it “Closed Tickets by Technician (with Bar Chart )”
  2. In the Report Header Band insert a Sub Band from the Actions menu.

 
  1. In the Sub Band insert Pivot Grid. Drag and drop Pivot Grid from the left panel in the Sub Band.

User-added image
 
  1. Now configure your Pivot Grid. You need to add row and column data for the Grid. Following are the steps
  1.   In the Actions menu Select Data Source and Data Member

User-added image
 
  1. In the Data menu configure your row and column data. To do this Create 2 fields (Data->Fields->Add)

 
User-added image
  1. We add 2 fields
  1.    PivotGridField1(Data Area)-Values present in column
User-added image
  1. PivotGridField2(Row Area)-Values present in row
User-added image
  1. Save your changes and Preview your Report. Check if the Pivot Grid reflect expected data in Table form. You can use this table in your report or choose to hide it. The Pivot grid is required to create Chart, hence it is essential we create the Pivot Grid.
User-added image
To hide the table, Behavior-> Visible (uncheck this)
 
  1. Now, in the Sub Band insert Chart. Drag and drop Chart from the left panel in the Sub Band.

User-added image
  1. Click on Run Designer. The Chart Designer opens up

User-added image

8. In the Chart Designer select Data Source - pivotGrid. This is the one we created in step 4.

 
User-added image
  1.    Under SeriesTemplate->View
select from the list of available charts. (For example-Bar)


User-added image

10. Click ok and save your report. Preview the report to check your Bar graph.
Note: You can similarly insert Pie chart (or any chart of your choice) by selecting it in step 9.
 
Track-It!
Track-It!
Track-It! 2019 and later
Attachment(s):