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]))))
So what's the question?
What's the question?
As stated in headline of my post, I'm looking for help with an expression regarding a count expression. I'm trying to count how many times the text "Section A" shows up in a column named Section between a specific date range.
The expressions look right to me.
I have it working now. Thanks!
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |