Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alert creation /Conditional Formatting to data

ash25sumbre
8 - Asteroid

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

6 REPLIES 6
mceleavey
17 - Castor
17 - Castor

Hi @ash25sumbre ,

 

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

 

mceleavey_0-1628156380517.png

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

 

mceleavey_1-1628156530484.png

 

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.



Bulien

HomesickSurfer
12 - Quasar

Hi @ash25sumbre 

 

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

 

sales1.PNG

atcodedog05
22 - Nova
22 - Nova

you have done some high-level stuff @HomesickSurfer 😎

ash25sumbre
8 - Asteroid

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

ash25sumbre
8 - Asteroid

Hi @HomesickSurfer ,

 

thanks for your help . I've try this and really amazing to create alerts  .

but  had small doubt if we have only column of actual sales and not of forecast sales .i.e. Week, Day, Date and Actual. 

Then how we can use variance and standard deviation based on actual values to create alert.

 

Can you please explain me ?

 

Also can we use any other statistical method ?

 

the help will greatly appreciated.

 

 

ash25sumbre
8 - Asteroid

Hi @mceleavey 

 

thanks for the solution . It helped me a lot .

 

Can you please explain me the alternative part  little more in detail/with example which you posted in comment ?

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

 

 

Labels