Splunk Cloud Platform

Avg of column with case statement

Splunkerninja
Path Finder

Hi,

I want to find the grade based on my Case condition but my query is not working as expected.

| eval Grade=case(Cumulative=1,"D", Cumulative>1 AND Cumulative<=1.3,"D+")]

Example: My Grade should be based on the avg(GPA) If Avg(GPA) is 1 Grade at the bottom (Avg Grade)should be D , If it is between 1-1.3 then it should be D+

 

Splunkerninja_0-1701177073877.png

 

 

Labels (2)
Tags (4)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Shouldn't your eval be something like this

| eval Grade=case(GPA=1,"D", GPA>1 AND GPA<=1.3,"D+")]

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Shouldn't your eval be something like this

| eval Grade=case(GPA=1,"D", GPA>1 AND GPA<=1.3,"D+")]

Splunkerninja
Path Finder

@ITWhisperer 
 I want display the Grade based on the avg GPA and the below condition is not giving the result

| eval Grade=case(GPA=1,"D", GPA>1 AND GPA<=1.3,"D+")]

Splunkerninja_0-1701183698945.png

 

 

Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Your value (3.17) isn't covered by any condition in your case function which is why you don't have a grade. What are the ranges for your grades?

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...