Using this script to count all of the "section a" trips between dates and it sends back all of them, not withing the date range. Here's the script;
COUNT(Select(Trips[Section],
AND(
([Section]= "Section A"),
([Date]>=[_THISROW].[Start Date]),
([Date]<=[_THISROW].[End Date]))))
I've tried using the ID field instead of Section with the same results.
I've tried this one as well with same result.
COUNT(FILTER("Trips",
AND(
([Section] = "Section A"),
([Date]>=[_THISROW].[Start Date]),
([Date]<=[_THISROW].[End Date]))))
User | Count |
---|---|
30 | |
16 | |
3 | |
3 | |
3 |