Create and save a Pivot
This topic shows you how to use pivot to create and save a simple report. This example uses the data model datasets that you created in the previous chapter. If you do not have them, refer to Create a new data model.
This is a very simple example. More complicated examples are shown in later topics of this tutorial.
Create a new Pivot
When you set out to design a report, you first need to select a data model that represents the broad category of event data that you want to work with. For this tutorial, that data model is the "Buttercup Games".
- Select Settings > Data models.
- In the data models list, click Buttercup Games.
This takes you to the Select a Dataset page.
The Buttercup Games data model has a root dataset to track Purchase Requests from the game website. The Purchases dataset breaks down into Successful and Failed purchases.
- Select "Purchase Requests".
This opens a New Pivot editor for the Purchase Requests dataset.
By default, the Pivot Editor interface displays elements to define a pivot table. There are four basic pivot element categories: Filters, Split Rows, Split Columns, and Column Values. When you first open the Pivot Editor for a specific dataset, only two elements will be defined:
- A time range Filter element (set to All time).
- A Column Values element (set to "Count of <dataset_name>".
- Select the Single Value Display element from the visualization bar.
- Next to Caption, type Purchase Requests.
- By default, the time range filter element is set to All time.
- Single value visualizations (single value, the three gauge types) use the first column value element to get their single value. Here, the field is "Count of Purchase Requests".
- Single value visualizations do not use Split Row or Split Column elements.
- You can format the number's precision and select whether or not to use a comma.
Save the Pivot as a report
After you define a pivot, you can save it as either a report or a dashboard panel. In this example, you save the single value display as a report. Dashboards and dashboard panels are discussed in a later chapter.
- Click Save As... and select Report.
The Save as Report dialog box opens.
- Enter a Title "Total Purchase Requests" and Description (optional).
- Select Yes to include the time range picker.
- Click Save. After the report saves, a window displays that "Your report has been created". You can continue editing the current Pivot, add the pivot to a dashboard, change additional settings for the saved report, or view the report.
- Click View to view the report.
View saved reports
A report that is created from Pivot will always be saved under the current app and owner namespace.
- Click Reports in the app navigation bar to view the list of all saved reports.
- Use the arrow in the i column to view information about Total Purchase Requests report.
- Click the report name to view the report.
In this topic, you created and saved a report using Pivot. Continue to the next topic to create more pivot visualizations.
Create a pivot table
This documentation applies to the following versions of Splunk® Enterprise: 6.5.0, 6.5.1, 6.5.1612 (Splunk Cloud only)