Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=count({<DisplayDate = {">=$[Begin Date] <=$[End Date]"} >} [Team Name])
try below
=count({<DisplayDate = {"=DisplayDate >=[Begin Date] and DisplayDate <=[End Date]"} >} [Team Name])
try below
=count({<DisplayDate = {"=DisplayDate >=[Begin Date] and DisplayDate <=[End Date]"} >} [Team Name])