Count occurrences based on parameter control?

Question & Answer
,
1

I have a control that allows users to select multiple weeks. I then need to be able to count how many of those weeks include an entry on a Friday. How do I get the calculated field to cycle through the selected weeks and count the specific days?

2

hi @durl,

Would those weeks in multiple selection be string data or date type in QuickSight? how does it appear in dashboard? if you could provide sample data and visual you want to show, that would be helpful.

kind regards,
Wakana

3

Hi @durl,
could you create a new field ISFriday countIf(extract('WD', date)=6,1,0)
based on the control you could then filte the relevant weeks and sum(ISFriday).
BG

4

ErikG

I like that idea. I’m going to give that a try. Thanks.