Setting up an alert

domoexpert

Hi Team,

I want to set up an alert for my data whenever a new month comes in. Can you please advise how can i set that up considering i have a date field.

MarkSnodgrass

You would need to add an additional output dataset, but if you did a group by to get the max date in the dataset and then also apply the LAST_DAY() function to make normalize to a single date in a month. This should give you a single row. You can then set the alert for when the any row has changed.

Hope this helps.

domoexpert

Cant i just set up an alert for when the max of my date column changes?

MarkSnodgrass

Possibly. Something like this might work.

Ashleigh

You can also set a dataset alert that tells you when a new row is added. Just select whatever options make your rows unique in the last section.

domoexpert

@Ashleigh I dont see the option of any row is added in the tab. Any particular reason?

Ashleigh

Are you trying to set up the alert on the card or on the dataset?

domoexpert

Dataset @Ashleigh

Ashleigh

For me it shows up at the top

Ashleigh

You may also be able to select your date field and do a unique count or maximum and have it alert you on that

domoexpert

I did set up an alert and the data changed as well but i did not get any notification

Ashleigh

what was your alert criteria?

domoexpert

Sum of sales increases by 1 or more. The criteria was met. But the alert was not triggered.

The same alert was triggered when i tried the data on an excel file but it doesnt get triggered through a federated connection

@Ashleigh

domoexpert

@Ashleigh Still waiting to hear back

MarkSnodgrass

Are you receiving alerts on other cards or datasets? I would try creating a test dataset or card and creating an alert and then changing the data that forces the alert and make sure that you receive it. You can use the Domo Webform to quickly create a dataset and update it, or you could upload a sample Excel file. This would rule out that it isn't your company's e-mail system keeping you from receiving the alert.

JasonAltenburg

@domoexpert

"The same alert was triggered when i tried the data on an excel file but it doesnt get triggered through a federated connection"

To me, that sounds like something you would want to submit a support ticket on.

Ashleigh

@domoexpert sorry for the late response! It def sounds like it could be something buggy, I would double check notification settings and maybe set up another alert to see if that one gets triggered.