Database Reference
In-Depth Information
How to make a sparkline panel
Sometimes, it is interesting to be able to easily compare the ups and downs of various cat-
egories of an indicator field in one visualization. Sparklines allow you to do this, as they
can easily track trends. They are very small line charts.
To create a sparkline panel, take the following steps:
1. Using the
buttercupgames
data, type the following code into the search bar:
sourcetype=access* | chart
sparkline(count(eval(action="purchase"))) AS "Purchase
Trends" count(eval(action="purchase")) AS Total by
categoryId
Note
It is very important that you spell
categoryId
exactly as it is written, with one
capital I and no other capitals. Otherwise, this code will not run.
2. For each
categoryId
type, you will see a sparkline showing purchases over
time that has been renamed
Purchase Trends
, and a count of the subtotal labeled
as
Total
, as shown in the following screenshot:
