Part 6 Add a single value visualization using a chain search

In this part of the tutorial, add total revenue as a single value visualization to your dashboard. You can add a single value by attaching the visualization to a data source and adjusting visual formatting options. By adding total revenue as a single value in the Buttercup Games dashboard, you can highlight an important metric in a way that's visually compelling.

  1. Select the add chart icon (A bar graph as an icon.) in the editing toolbar, and then select Single Value.
  2. By default, the New Data Source panel pops up. Because you want to create a new chain search data source, select Cancel.
  3. In the Data Configurations section of the Configuration panel, select + Set up Primary Data Source.
  4. Select + Create Chain Search and name the search Total Revenue.
  5. Select Revenue by Game in the Parent Search drop-down menu.
  6. Add your extended search. For this tutorial, copy and paste the following search into the Search with SPL box: 
    | stats sum(Revenue) as "Total Revenue"
  7. Expand the Code section and change the Data Source ID to ds_total_revenue.
  8. Select Apply & Close.
  9. In the Selected Data Field section, select Total Revenue (number).
  10. In the Major Value & Trend section, follow these steps:
    1. Change the Unit Position to Before.
    2. Enter $ for the Unit Label.
    3. Increase the Precision value to 2.
  11. Turn the Sparkline off.
  12. Change the Static Background to transparent.
  13. Expand the Code section and change the Visualization ID to viz_totalRevenue.
  14. Move and resize the single value so that it fits inside the center of the donut chart.
  15. Add a title to the single value visualization by selecting the add Markdown icon (An uppercase letter M and an arrow pointing downward as an icon.) in the editing toolbar.
    1. Enter ### Total Revenue in the text box.
    2. Resize and position the text box to fit above the single value and inside the donut chart.

    Note: You can add a title and description in the Visualization Options section of the Configuration panel, but adding separate text boxes provides more flexibility in visual formatting.

After completing Part 6, your single value inside the donut chart looks similar to the following:

A donut chart with a percentage revenue break down of each game and total revenue shown in the center.

Next step

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

Now your dashboard has a single value visualization. Next, adda map showing the connection between geographic locations and purchases. Continue to Part 7: Add a map.