Hello. I have an application that needs to show counts based upon the date the user selects. They can select a single month from the list box and the displayed counts should reflect that selected month's values.
The source data has a begin and end date on the records, so I want counts where the user selected month falls between these two date fields.
Team
Count
Begin Date
End Date
A
1
7/1/2019
6/30/2020
B
1
11/11/2019
11/11/2020
In this example, for Team A, I would want the count to reflect '1' if the user selects a date between July 2019 and June 2020, but anything before July 2019 for Team A would be '0' and anything after and including July 2020 would be '0'.
My attempts with set analysis isn't working. The count doesn't change when I switch in and out of that range.
