Part 4 Add a pie chart visualization

As a representative of Buttercup Games, you need to present a breakdown of the store's revenue comes. In Splunk Dashboard Studio, you can add a pie chart visualization and choose between a pie or donut appearance. To showcase the revenue breakdown, create a donut chart that divides the store's total revenue by game.

1. Select the add chart icon () in the editing toolbar, and then select Pie.
2. In the New Data Source panel, name the source Revenue by Game.
3. Add your search. For this tutorial, copy and paste the following search into the Search with SPL box:

   index=main sourcetype=access_* action=purchase status=200 
   | stats count values(price) as Price by productName productId 
   | table productName productId count Price
   | eval revenue=count*Price 
   | fields productName revenue
   | rename productName as "Game" revenue as "Revenue" 
   | sort -Revenue
   

4. Expand the Code section and change the Data Source ID to ds_revenue_by_game.
5. Select Apply & Close. At this point, you've created a new data source, given it a unique ID, and assigned it to a pie chart.
6. Title your pie chart Revenue by Game and leave the description box empty.
7. In the Appearance section of the Configuration panel, select Donut.
8. In the Labels section, select Values & Percent.
   1. For Dashboard Studio in Splunk Enterprise versions 8.3.1 and earlier, in the Labels section, select Show Values. Showing percentages is currently unavailable for Dashboard Studio in Splunk Enterprise versions 8.3.1 and earlier.
9. Expand the Code section and change the Visualization ID to viz_gameRevenue. At this point, you've given your chart a unique ID, changed its appearance to a donut, and labeled each game with a percentage.
10. Move and resize your pie chart to center it on the bottom left gray rectangle.
11. In the General section of the Configuration panel, change the Background to transparent.
    1. For Dashboard Studio in Splunk Enterprise versions 8.3.1 and earlier, you can change the background color by opening the source editor and adding the option "backgroundColor": "transparent".

After completing Part 4, your donut chart looks similar to the following:

Next step

You've completed Part 4 of the Splunk Dashboard Studio tutorial.

Now your dashboard has a donut chart. Next, show purchases in relation to time by adding a column chart. Continue to Part 5: Add a column chart.