topic Re: SAS visual Analytics in SAS Visual Analytics

SAS visual Analytics

krishnaavm123 — Mon, 19 Feb 2024 08:05:13 GMT

Hi Team,
Currently I have a date slider (where users choose from and to date date ranges on date slider) , and I have a calculated item with following formula
(if tier_keywords='tier2'
Return alertcount*0.1
Else alertcount)

I wanted to cap threshold for this calculated field to 10% of alerts for tier2 keywords.

The issue I had for some date ranges total alerts count is below 5 and threshold going to be below 0.5 and at front it returns 0 as a lower integer number if I use ceil the threshold is going high for some date range filters.

Kindly advise how to handle this threshold to be calculated and capped to 10% of alerts. Thanks in Advance

Re: SAS visual Analytics

KeithM — Tue, 20 Feb 2024 18:20:18 GMT

In the example below, consider Cylinders as your AlertCount data item. I assume you would need an aggregated calculation. In the "IF" condition, you would define your min and max thresholds. In the example below, the min threshold =1. The max threshold=100.

Re: SAS visual Analytics

krishnaavm123 — Wed, 21 Feb 2024 01:04:10 GMT

Hi Keith ,
Thanks for your reply and I also wanted to check one more condition that is if alerts being tagged to tier2 then only calculate to 10.

Can U PLS help on this logic when I applied another and condition to check if stream is tier2 it's thrown an error type mismatch and if one operand can only be used in grouped manner.