Multiple conditions case statements

codedtech — Thu, 11 Feb 2021 17:34:16 GMT

I'm running a query to label memory thresholds for our app clusters, I would like to create a field called "eff_mem_threshold" based off the number of blades app name. But for the life of me I can't figure out why this case statement isn't working. What I mean is that it only returns the eff_mem_threshold value of the first pair for each app and blade count. I've added an example below the case statement

Case statement

query|eval eff_mem_threshold =case(APP_NAME="EXCH_AD" and Blades<=5, 40,APP_NAME="EXCH_AD" and Blades>=17,46,APP_NAME="EXCH_AD" and Blades>=6 and Blades<=16,44,APP_NAME="VCO" and Blades<=5, 56,APP_NAME="VCO" and Blades>=17,64,APP_NAME="VCO" and Blades>=6 and Blades<=16,61,APP_NAME="SQL" and Blades<=5, 68,APP_NAME="SQL" and Blades>=17,78,APP_NAME="SQL" and Blades>=6 and Blades<=16,74)

what I see

APP_NAME	Blades	eff_mem_threshold
EXCH_AD	15	40
EXCH_AD	4	40
SQL	17	68
SQL	9	68
VCO	17	56
VCO	4	56

What I'd want to see

APP_NAME	Blades	eff_mem_threshold
EXCH_AD	15	44
EXCH_AD	4	40
SQL	17	64
SQL	9	61
VCO	78	56
VCO	4	56

Re: Multiple conditions case statements

scelikok — Thu, 11 Feb 2021 18:19:04 GMT

Hi @codedtech,

The only reason seems to be is Blades field value is zero or less than 6. Is it possible that Blades count values are being calculated after this eval? Can you please share all SPL?

Re: Multiple conditions case statements

codedtech — Fri, 12 Feb 2021 19:08:04 GMT

That was it, sometimes staring at your own code can make you miss the simple stuff.

topic Multiple conditions case statements in Alerting

Multiple conditions case statements

Re: Multiple conditions case statements

Re: Multiple conditions case statements