Cisco Cisco StadiumVision Mobile Reporter Manuale Di Manutenzione
Cisco StadiumVision Director Proof of Play
Cleaning Up Proof of Play Data
23
b.
Select the rows that you want to include in the PivotTable. This updates the Microsoft Excel toolbar.
c.
Select Insert > PivotTable from the tool bar. The Data > PivotTable toolset displays in the ribbon
menu:
menu:
d.
Click on the “Change Source” tool in the ribbon. The Change PivotTable Data Source dialog box
displays.
displays.
Note
The information displayed in the dialog box will be incorrect as it will reference the Example
Data Set tab.
Data Set tab.
e.
Type the Location for the data set. Follow this string format with the tab that contains the data set
and the row value obtained in Step 2b:
and the row value obtained in Step 2b:
'your_summary_report.csv'!$A$1:$Q$28263
f.
Click OK.
Step 4
Repeat Step 3 to update the other sheets within the PivotTable file.
Step 5
Save the modified template example_pivot.xlsx file as a .xlsx formatted file with a new name so that you
do not overwrite the example.
do not overwrite the example.
Step 6
You can delete the sample Example Data Set tab to reduce the file size. Simply right click on the tab and
choose Delete.
choose Delete.
Cleaning Up Proof of Play Data
You should clean up proof of play data at the end of the season, or at another time when it is appropriate
to remove event-related proof of play data from Cisco StadiumVision Director to help maintain the
availability of your server storage.
to remove event-related proof of play data from Cisco StadiumVision Director to help maintain the
availability of your server storage.
This section includes the following tasks:
•
•