I am using Pivot to create a dashboard full of pretty charts. Some of these charts lend themselves to having a trendline drawn on them. However, I can't seem to plot a trendline in Pivot. Am I missing something obvious or is this an advanced scenario where I need to bust out the command reference and do it via normal search means?
Trendlines aren't available for the initial release of Pivot. You can use Pivot in conjunction with the old-school method of adding trendlines to charts by getting the pivot search string...
pivotcommand to code searches using it.
...and then using that search string in a larger search that uses the
trendline command to plot a trendline. Or you could set up a dashboard panel that utilizes some tricksy implementation of chart overlay (pivot chart over trendline chart)...whatever works best for you.
That makes sense then. I was able to use the datamodel command in order to take advantage of the information I already had organized there. a very simple example below;
| datamodel TicketData Ticket_Index search | search | timechart count | trendline sma2(count) as Trend