Alerting Help - Average Value & Rounding

FormerMember

So I found some nice templates here in Thwack to use to spruce up our alerts. Annoying that it's gotta just be 1 line for it to format correctly, but anyway.....

We're leveraging these variables:

${N=SwisEntity;M=ComponentAlert.StatisticData}

${N=SwisEntity;M=ComponentAlertThresholds.ThresholdStatisticWarning}

${N=SwisEntity;M=ComponentAlertThresholds.ThresholdStatisticCritical}

So our alert shows us something like:

Current Value: 80.98132123

Warning Threshold: 75

Critical Threshold: 90

This is a generic component alert and I'd like to be able to add in a "Average Value" line, but can't seem to find that variable anywheree, anyone know if it exists?  Also is there a way to round the current value to 2 decimal places? I searched around and someone mentioned using a 'truncate' but I can't figure out the correct means of executing it.

Sorry if this should be in another section.

tomiannelli

Average value will need to have a period of time associated with it to calculate that number. You would have to pull all the historical values for a period and calculate the average. You could design that using SWQL I suppose.

Check out adatole​'s posts or e-book. Advanced Report Alerting - The eBook

SWQL Studio will give you a lot of insight into all the data at your disposal.