Create a report from a sparkline chart
In this example, you create a report that shows the trends in the number of purchases made over time. This example uses sparkline charts. Sparklines are inline charts that appear in the search results table and are designed to display time-based trends associated with the primary key of each row.
For searches that use the stats
and chart
commands, you can add sparkline charts to the results table.
This example uses the productName
field from the Enabling field lookups section of this tutorial.
If you do not configure the field lookups, the searches in this section will not produce the correct results.
- Start a new search.
- Set the time range to All time.
- Run the following search.
sourcetype=access_* status=200 action=purchase| chart sparkline(count) AS "Purchases Trend" count AS Total BY categoryId | rename categoryId AS Category
This search uses the
chart
command to count the number of purchases by usingaction="purchase"
. The search specifies the purchases made for each product by usingcategoryId
. The difference is that the count of purchases is now an argument of thesparkline()
function.When you rename a column using the AS keyword, names that are more than one word need to be in quotation marks. In this search quotation marks are around the name Purchases Trend but not around the name Category.
- Click Save As and select Report.
- In the Save Report As dialog box, for Title type
Purchasing trends
. - For Description, type
Count of purchases with trends
. - Click Save.
- In the confirmation dialog box, click View. Your report should look like this.
Next step
This completes Part 6 of the Search Tutorial.
Up to now, you have saved searches as Reports. Continue to Part 7: Creating dashboards, where you learn how to save searches and reports as dashboard panels.
See also
chart command in the Search Reference
Add sparklines to your search results in the Search Manual
Create a report from a custom chart | About dashboards |
This documentation applies to the following versions of Splunk Cloud Platform™: 9.2.2406 (latest FedRAMP release), 8.2.2201, 8.2.2202, 8.2.2203, 9.0.2205, 9.0.2208, 9.0.2209, 9.0.2303, 9.0.2305, 9.1.2308, 9.1.2312, 9.2.2403, 8.2.2112
Feedback submitted, thanks!