Can threshold alerts be set on a table instead of individual and specific cells?

Q&A
, ,
1

Hi, I have a Quick Sight dashboard that is tabular and displays the following fields:
Field1 | Field 2 | Field3

I will like to be alerted when there are duplicate values at the Fields1 & 2 level. For example:
row no. | Field1 | Field 2 | Field3
row #1 | A | A | X
row #2 | A | A | P
row #3 | A | Z | X
row #4 | B | B | J
row #5 | B | B | K
row #6 | C | C | T

Rows #1 and #2 are considered duplicates of each other. Rows #4 and #5 are considered duplicates of each other.

Is there any way to alert me when such combinations show up in my Quick Sight? The reason I’m asking is because from my rudimentary understanding, is:

  1. threshold alerts can only be applied on a numeric value comparison (and in my case, it’s not even a change in a cell value)
  2. threshold alerts can only be applied to a specific, pre-identified record (in my case, the duplicate combinations can occur across any no. of random records across the entire table.

Hence asking if there are other ways I can be alerted when such situation appears?

Thanks.

1 Like
2

Hello @qsnoob , welcome to the Quick Sight community!

The best way to get around this is with an ifelse calculation.

You could create something like the following:
ifelse({field1} = {field2}, 1, 0)

Then set your threshold alert to trigger if the value in your calculation ever equals 1.

Let me know if this helps!