Window functions to create custom warnings

Question

Hello,

Hope everyone is doing well and safe!

I am required to process large amounts data in excel files which are generated every 15 seconds.

I am looking to create custom warnings.

Example warning, "if amplitude <1 lasts 1 hour". (1 hour is dynamic, it can change every few months, can become 2 hours or anything else)

I have columns for amplitude like Amp1, Amp2... till Amp 22.

I have the data log with date and time format: mm/dd/yyyy hh:mm:ss

It should return the timestamp and which amplitude number it belongs to. For example Amp1 or Amp2 or....

The warnings should be displayed on the dashboard(in qlik) and in an email.

Can you please tell how can I achieve this?

Any help would be greatly appreciated.

Thank you

Regards,

Pankhudri

Pankhudri20 · Answer

Hello @BrandonB

Thank you for your response.

I have created a small sample file for your reference.

C1, C2, C3...C11 are the cell numbers required in the warnings.

warning condition:

if amp <1 lasts 1 hour (1 hour is a dynamic number, can change)

Any help would be greatly appreciated.

Thank you

Regards,

Pankhudri

Sample_data_alteryx.xlsx

BrandonB · Answer

Can you provide some sample data? It would probably be easiest to use a multi field tool for the calculations and then possibly a test tool if you are looking to have it throw an actual error or warning if a condition isn't met.