Is there a way to count capsules?
For example, I have created a value search in my data to show me all values above 70%. This forms capsules at the top of my timeframe. However I would like to now count how many capsules are in the selected timeframe (ie from November to January). I have tried using the "count" formula however it is showing a trend with a value every time the value search shows above 70%. I am looking for something that will tell me there were 87 capsules in the timeframe. And if I change the timeframe, then this value would change. I hope this makes sense.
Thank you!