Dashboard Studio Single Value with Trendlines

[chrisboy68]

Hi, struggling to get single values to show with trendline comparing to previous month.

| bin span=1mon _time
| chart sum(cost) as monthly_costs over bill_date 

Tried differnt varations. The above will show a single value for each month, but I want to add a trendline to the single value to compare to the previous month. Any ideas?

Thanks!

[chrisboy68]

Hi, this https://docs.splunk.com/Documentation/Splunk/9.4.0/DashStudio/trellisLayout.  Specifly like this sample.  With each month, cost and the trend line comparing to previous month.

[ITWhisperer]

So far, you have only mentioned 2 dimensions, cost and time - what else are you breaking your statistics down by?

[chrisboy68]

This is probably why I'm getting confused.

Jan	100
Feb	105
March	90

Given this table, I want to have a single value trellis view that depicts the month total , with a trend compared to the previous month.

Jan 100 (no trend) , Feb 105 (shows trend up 5), March 90 (shows trend down 15).

I'm going to play with timewrap, maybe I'm going down the wrong path.

[ITWhisperer]

| bin span=1mon _time
| chart sum(cost) as monthly_cost over _time

[chrisboy68]

Keep getting "Select a valid trellis split by field", used "_time" and tried "monthly_cost" . 

[ITWhisperer]

"Trellis"? Where did that come from? Please clarify what you are actually trying to do?