Data Model and Pivot Tutorial

Create a pivot chart

In the previous topic you used Pivot visualization editor to build a table. In this topic, you will use the same dataset to create chart visualizations.

Define a new Pivot

1. From the Splunk bar, select Settings > Data models.
2. Select the Buttercup Games data model.
3. In the Datasets editor page, click Pivot.
In the Select a Dataset page, select the Successful Purchases child dataset.

The New Pivot editor for Successful Purchases opens.

Add Pivot elements

For the pivot chart, let's report on the count of successful purchases by category. To do this, you will add a Split Row using the categoryId field.

1. Under Split Rows, click + and select categoryId from the list.
   




2. For Label type Category and click Add to table.
   
   This returns the following Pivot table.

Change the visualization type

1. Click the Column Chart icon from the visualization bar.
   
   The New Pivot editor for the Column chart displays.
   • Column charts use the first split row element in pivot table definitions to provide their X-axis values. In this case, that Split Row is Category.
   • Column charts use the first column value element in pivot table definitions to provide their Y-axis values. Here, that Column Value is Count of Successful Purchases.
   




This data can also be visualized as a pie chart.

2. Click the Pie Chart icon from the visualization bar:
   The New Pivot editor for the Pie chart displays.
   • Pie charts use the values from the first Split Row element (Category) to determine the number and colors of their slices.
   • Pie charts use the first Column Value element (Count of Successful Purchases) to determine the relative sizes of their slices.
   
   Mouseover a slice of the pie chart to view the metrics: Category, Count of Successful Purchases, and percentage of the total Count of Successful Purchases.

Next steps

In this chapter you created three pivots and saved two of them as reports. This last pivot chart, you will save as a dashboard panel. Continue to the next chapter to read about dashboards.