Hi Quicksight Community team,
Thank you for all the help you’ve provided to me so far!
I wanted to ask for some brief advice for how to get started on a new task.
I want to use Quicksight Tables to create alerts for my users, to let them know when specific data falls below a certain threshold.
Specifically: I will get y-values for a combination of column filters, and I want to see which combinations of filters yields a y-value that falls below the overall average.
I was thinking of creating two tables: one to show the y-values for each of these combination of filters and another table which grabs from the first table and outputs the y-values that fall below this threshold.
This approach seem a bit clunky, however. So I was wondering if you could point me to a better solution!
Thank you,
Oliver
hi @olivercarmont - Can you please have a look on the below documentation - Working with threshold alerts in Amazon QuickSight - Amazon QuickSight
If it is not helping , can you please share sample input and expected output or condition for alert.
Regards - Sanjeeb
2 Likes
Hi Sanjeeb,
Thank you for the response.
I took a look through the documentation and it looks like it won’t fulfill my needs.
As you point out, a visual could help:
(The second table is just a duplicate of the first for now)
So my goal is to have different combinations of metrics in my first table.
Then, I wanted to have a second table where I list all the combinations of metrics where experiments differed by a Y value of say, 20% or more.
There could be two, three or more experiments. The important thing is: I want to compare by the same metric values, so metric 1 = 20, metric 2 = 30, etc. for two experiments and the y-value for the different experiments differed by 20% or more.
Do you know how I could implement this? Thanks!
Hi there,
I found a solution to my issue!
What worked for me was using the avgOver and minOver calculated values to aggregate column values and compare a given row with it’s overall “category”.
In short, I used them in the following manner:
If I wanted to find how a row’s column compared to the minimum of that same column in it’s “category” where I define category as a combination of metrics, I would use the following formula:
minOver({Y_VALUE}, [{metric_1}, {metric_2}, {metric_2})
Finds minimum in overall category
avgOver({Y_VALUE}, [{metric_1}, {metric_2}, {metric_2}, {specific_category})
Finds average of specific category
Using these two values, I could compare how a row’s y-value column would compare with the rest of the data in its category.
Hope that helps anyone who had a similar issue 
2 Likes
Thank you @olivercarmont for sharing the solution. This is definitely help to wider community.
Regards - Sanjeeb
1 Like
