Splunk Search

Build Chart (Score Sheet) that shows all assignments (even missing)

troyward
Explorer

So I have score information for a variety of challenges completed by a number of people. I want to build a chart showing their score information for each challenge individually. Building the chart is easy enough, my problem is that if they haven't completed the challenge (i.e. no score) then the challenge won't show up at all. I have a lookup table with a complete list of the challenges. Is there a way to force all challenges (even the ones without the scores) to show up or to generate or 0 score if the assignment isn't there?

Thanks,

Troy

Tags (2)
0 Karma
1 Solution

cmerriman
Super Champion

I would maybe use append with the lookup of all challenges.

Something like

...|stats count as completed_challenges by challenge contestant
 |append [|inputlookup challenges.csv]
 |fillnull completed_challenges value=0
 |stats sum(completed_challenges) as completed_challenges by challenge contestant

View solution in original post

cmerriman
Super Champion

I would maybe use append with the lookup of all challenges.

Something like

...|stats count as completed_challenges by challenge contestant
 |append [|inputlookup challenges.csv]
 |fillnull completed_challenges value=0
 |stats sum(completed_challenges) as completed_challenges by challenge contestant
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...