Alert creation /Conditional Formatting to data

Question

Hi Everyone,

I'm new to Alteryx please help me to deal with this scenario.

I have sales data attached in the question and want to add alerts on basis of different conditions.

1. My main aim is I want to throw an alert for each weekdays. I wanted to check that Is my every Monday( or any other workday)  sales falls within range or not ? if not its throws an alert  .

So How should I proceed to create that alert ??

other than average can we use any other statistical term like variance/Standard deviation  for that?

Also can we add any holiday logic to this ?(public holidays )

Please suggest if you ideas. Help will be greatly appreciated.

Th

Sales.csv

mceleavey · Accepted Answer

Hi @ash25sumbre ,

You can use the email tool to trigger an alert as below:

This is checking that figures fall within a range, then creating a table and emailing this to a recipient.

I've attached the workflow.

Alternatively, you can use the message tool to trigger an error, and use this in conjunction with the Events tab to create an event on error.

This depends on the use case.

The workflow I've attached will send you an email when the sales fall within a range for a given week.

Hope this helps,

M.

HomesickSurfer · Accepted Answer

Hi @ash25sumbre

Try this.  Modify attached wf accordingly to suit your thresholds.

ash25sumbre · Accepted Answer

Thank you for your help . it Looks great .I will try this