2020欧洲杯投注备用

TIPS & TRICKS

Dashboard Digest Series: Episode 7 – Iron Splunk

2020欧洲杯投注备用Welcome to Episode 7 of the Dashboard Digest series!

2020欧洲杯投注备用This is an exciting post for me today as a few days ago was my 5-year anniversary with Splunk! Well, that and I completed a bucket list item which is part of this post and the dashboards. Let me explain...

Five years ago I set out to do a full Ironman. In fact, 5 years ago a question during my interview with Splunk was: "What is your biggest goal this year?" and I answered "an Ironman!". Sadly, shortly after this interview I suffered a severe ankle sprain that permanently destroyed cartlidge between my leg and foot. The next 5 years equated to multiple ankle surgeries and 4 years of on-and-off physical therapy. It hasn't been fun but alas, I’ve made progress.

This past Sunday, however...I completed the Boulder Ironman!

The run portion wasn't pretty given the 97-degree heat, but I did it. And what better way to document that journey than to Splunk it!

Today I'll show you a dashboard that documents my 6-month training journey and uses the Status Indicator Custom Visualization, Link Switcher and Event Annotation which was added in Splunk 7.0. The first question many of you might have is why wouldn't you just use Strava? Well, I did, but Strava didn't have an input for beer consumption during training OR have the ability to build analytics ANY WAY I want it. As for getting the data in, the good news is you can use the Add-on Builder to automatically poll Strava's API to get the information in to Splunk constantly and the Lookup Editor App to manually input any other information you'd like.  

Purpose: Create an easy and flexible way to track exercise/training stats in Splunk
Splunk Version: Splunk 7.1
Data Sources: Data from Strava's API, manual input into Lookup Editor App
Apps: , , ,
Related Posts:2020欧洲杯投注备用 Scroll to bottom of page

2020欧洲杯投注备用Let’s get started with getting the data in. If you haven’t already used the to get REST API (and more) information into Splunk, you’ve been missing out! It makes getting this kind of data into Splunk exceptionally easier than before.  

2020欧洲杯投注备用I simply downloaded and installed the App, clicked “New Add-on” and followed the steps. Adding a logo is easy as well—I simply picked Strava’s main icon.

2020欧洲杯投注备用The main step involves finding the right API call to get the information you want. After creating my developer account and getting an access token, I then browsed through to find the URL I needed to get activity information back. Next, I plugged this information into the add-on builder and hit “Test” to see the results. It worked!

Finished. Now you just enable the input you created and you’re off. I checked my index to see if information started coming in, and success! Time to start building dashboards. Well, almost...

The other data I wanted to use comes from manual entry. This could be anything, and in my case, I wanted to track some other variables along my journey such as injury notes, vacations, beverages consumed and more. The is a perfect way to update static data sets as a .csv file. Before I started polling Strava, I was manually putting my exercise information in here as well as you can see below. Note the vacation and “beverage consumption” entries—these will be used for Event Annotation2020欧洲杯投注备用 in the dashboards which you’ll see soon.

Okay, NOW we're ready for some dashboards. The goal was to make a simple but flexible dashboard to view training activity and trends, and overlay certain events. It's nothing fancy, but the use of Event Annotation and Link Switcher might be something you're interested in adding to your own dashboards.

Let’s start with the . These are useful for adding some additional context to your single values; in this case, it helps show which sport the value is associated with. I find it easier and more intuitive to understand than just having to read text in the title, and they can also change colors of the icon itself in real-time using conditional statements in your Splunk search. I made the colors match the data in the charts below to make it visually easier to connect the activities. This top bar is meant to show overall miles by activity in the 6 months of training.

Next, I wanted to break things down over time and add some overlays and trends. The different form inputs help update the chart to my liking. For example, do I want to see all activities at once? Do I want to show total duration of activities or the distance traveled? And how about that integral part of my training involving my favorite beverage? ;)

You can find out how to build and use these form inputs from the  app. This app will show you everything you need to know in creating these—I highly recommend you download! I also provided a time span option to change the chart from 1-day to 3-day to 1-week intervals.

Let’s hit that beer button. This replaces the overall exercise duration trend overlay with beer consumed amounts per day using the right y-axis. 

If you can’t tell, I didn't give up beer drinking throughout this journey; I enjoy it too much, and...it has carbs right?! To add chart overlays like this, check out the example in the  app.

How about those dotted lines you see? Event Annotation is a great way to overlay specific events in time on your charts. The blue and orange events were some long vacations where I found it difficult to maintain training. (I think I needed the rest anyways). The black one however was an unplanned knee injury—I’m thinking from over-use on the bike during some climbs. We can see the effect on subsequent training from there; it definitely put a dent in my plan. Changing the time span to 1 week and hovering over the event annotations, we can see what happened to my total exercise time during these periods. Luckily, the knee injury wasn’t too serious but still put me back a bit in training.

2020欧洲杯投注备用Vacation: Skiing in Japan I wasn’t able to maintain my exercise plan. Oh well, it was worth it!

2020欧洲杯投注备用Knee Injury: I think I increased my mileage and elevation too fast in biking, thus hurting my knee.

2020欧洲杯投注备用One way or another, it was quite a journey and I’m glad it's over with. I hope you enjoyed the post and can take advantage of the Form Inputs, Status Indicators and Event Annotation in your own dashboards! If you haven’t already be sure to check out the previous posts in the Dashboard Digest Series below.

Happy Splunking!

 


Related reads:

Dashboard Digest – Episode 5 – Maps!

Dashboard Digest – Episode 6 – Traveling on Time with Trellis

Dashboard Digest – Episode 6 – Traveling on Time with Trellis Part Deux

Stephen Luedtke
Posted by

Stephen Luedtke

Stephen started his career as a Network and Systems Engineer for one of the world's largest and most sophisticated communication networks—the FAA's Telecommunications Infrastructure. After 7 years and catching the data analytics bug, he found Splunk and joined as a professional services consultant. For almost 2 years he worked directly with clients to design and implement data analytics solutions using Splunk as a platform spanning almost every industry before moving to technical product marketing. After 4 years of building demos, enabling the field and presenting to audiences of all sizes, he just recently joined the blockchain team as a Data Engineer. Stephen is a Splunk Dashboard Ninja and Splunk's just about anything including his cars, thermostats, garden, energy usage and much more. He lives in Denver, CO with his wife and dog, loves beer, car racing and anything outdoors.

Join the Discussion