Alert Condition - Cannot Find Calculated FieldName

[#1]

Hello,

I am trying to setup alert. I created a Alert1 column (see attached), which means if sum(Alert1)>1, alert email will be sent.

Alert1 is a calculated column (not straight from dataset).

However, in the Alert Condition, I am unable to select Alert1 column directly. Is there a workaround?

I'm not sure if it will help providing the formula for the calculated field. Below is the calculation for Alert1 column, but please note this is at each recordset level. I want alert to be sent whenever sum(Alert1)>1, so basically any "RED" showing in the picture.

if

( ([Shopper Changes (T1 vs T7 Avg)]<-.3) and ([TXN-T1]>10), 1, 0)

[Miguel_Angel_Baeyens]

Hello,

Have you tried using yoru formula in the Alert? Because that's in the end what you are actually trying to watch. Since [Shopper Changes T1 vs T7 Avg] and [TXN-T1] are column labels, change the above using the expressions so labeled.

Hope that helps.

[#3]

I tried that but I don't think it is that simple due to "different aggregation levels" between expression set in columns versus expression set in Alert Condition.

I've copied the entire QVW. Alert1 expression is basically my Alert Condition, so use that as my objective.

Below is something I've tried, but defnitely not working so use it for reference only.

sum

( { <[Channel]={ICM}> } (([Shoppers-T1])/(Sum ([Shoppers-T7])/7)-1<.3) and ([TXN-T1] >10) ) > 0

BTW, if the Alert can be tied to the Visual Cues within Straight Table that would be much easier to setup Alerts.

Help is appreciated!

[#4]

Does anyone have an idea on how to setup this alert condition? I am stuck due to alert condition does not recognize the calculated expressions column that was created. Let me know if anyone has problem opening up the attachment.

Your help is appreciated!

[rwunderlich]

Youu cannot refrerence the derived chart column outside that chart. Use the aggr() function around your expression to specify the dimension values you want to aggregate against. You'll probably have to add a max() or min() or there as well to find values that should trigger the alert.

[#6]

I actually want to de-aggregate it since my Alert1 formula is at Placement level, so SUM() or AGGR() will not drilldown to the correct level.

I'm very surprised calculated field in a chart cannot be reference anywhere else in the QV for other objects to consume the value and take decision against it.

If anyone else has an idea how to refer to Alert1 Field in my Alert Condition, I would appreciate another prespective on this issue.

Sincerely!