Automate "Reporting" based on time frame to send out an email/notification

Hi all, I have a question regarding automating the reporting of a a reading on a dashboard. Let me start by giving you the data I have on hand:

I
Here, I order feedback from my users, segmented by rating and filtered by the tag “taste”. Each feedback has the following fields that are important to me:
feedback ID, rating, user id, supplier id
My goal is to create an SOP wherein any supplier who gets greater than a set number of negative ratings regarding taste (10 reviews in a week below 3 stars), an automatic notification or email sent out to the supplier and to the PIC at my company who ensures that the suppliers are doing a good job by right. I hope this explanation makes sense.
What sort of automations can be done with regards to this? Thanks!

Hi @rohit_SB

There is a feature to create alerts in QuickSight. Please check the following link and see if that serves your purpose.

Regards,
Giri

This isn’t exactly what I need. I’ve used this feature, but I’m not sure how it would work in my use-case. Would you be able to guide me through?

1 Like

Hello @rohit_SB and @Giridhar.Prabhu !

@rohit_SB have you been able to find a solution for this issue? It has been a while since there has been activity on this thread. If there is no activity in the next three business days this topic will be archived.

That being said, your best option for your use case will be threshold alerts:

1 Like

Hi @rohit_SB

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

Hi @rohit_SB

Since we have not heard back from you with any further information or follow-up questions, I will archive this topic. If you still need assistance, please post a new question in the community and link to this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts.

Thank you!