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