Filter DropDown box

[Amelie]

Please, could someone help with the following? I tried searching online for ideas, but I wasn't able to find any solutions so far.

I have an app where people can add if they were satisfied with the service experience (Dissatisfied, Satisfied and so on). After clicking submit button, the data is stored in SQL database. 

Then, I have the main screen, where I am counting the rows from the database for every item (how many were Satisfied, how Dissatisfied), and displaying them by week number. However, I want this information to be also filtered by Year. I added a dropdown list, but I am not sure what I have to do next (how to link the dropdown list to the data displayed in the screen).

Thank you!

[Amelie · Accepted solution]

I just managed to implement this 🙂  Added in my formula: Year(CreatedDate) = Dropdown.Selected.Value