Filter based on a calculation

Q&A
, , ,
1

I’m looking to filter my data based on a calculation I’m doing. For example, I have the following data:

Case Site sev created wk
132688 dac2 3 44
641138 dac2 5 35
321379 bcn1 2 42
323248 mad8 2 43
656879 ltn7 1 44
132498 dac2 3 44

From this I want to display all the data for any site with >=2 cases during wk 44:

Case Site sev created wk
132688 dac2 3 44
641138 dac2 5 35
132498 dac2 3 44

How could I filter the sites based on my calculation “countIf({case}, {created wk} = 44)”? I think I should do something like CountOverIf, but this function does not exist.

2

Hi @galaugus,

maybe you can create a new field
isKW44 = ifelse({created wk} = 44,1,0)
and then a
sumOver and/or sumif for Case using the new field.

BR

3

HI @galaugus
did you found an solution?
BR

4

@galaugus

Did @ErikG 's solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!

5

No, it was not asnwering my query. I end up performing a sumOver() and filter based on that. But thanks for the support!

6

Basically, I created the row level condition: Is_created_T7D (with a simple ifElse). This is giving me 1 if created during last 7 days and 0 if not. Then I’m doing the following: sumOver(sum({Is_created_T7D}), [{Site}])