Create alerts using Rules on sales Data

[ash25sumbre]

Hello Everyone.

While working on assignment I am not able to create alerts on  Actual sales data.

Please help me with some Ideas of 

1. how we can Create alerts using sales data ?

2. which statistical terms can be useful to create alerts and how can we use that?(eg. Variance, Standard deviation)

please help me with this . Help will greatly appreciated.

I've attached data  for reference.

[patrick_mcauliffe · Accepted solution]

Hey @ash25sumbre  can you attach samples of what you've tried already?  It's helpful to know what doesn't work so that we can direct you to something different (don't want to just repeat something you've already tried).

[ash25sumbre]

Yes ,sure @patrick_mcauliffe 

I have tried one with earlier help of community . the workflow is for when on weekdays there is no/zero sales. also tried on adding one column of forecasted values and calculated variance .

Also Please give some ideas how I can modify this workflows using different statistical terms/logic.

Suggest me with same.

Best Regards,

Aishwarya