Hi Splunk community, How to count number of "area" between time range to show results like these: Between 1/1/19 to 6/30/19, there are 2 areas Between 7/1/19 to 12/31/19, there are 2 Between 1/1/20 to 6/30/20, there are 0 Between 7/1/20 to 12/31/20, there is 1 Between 1/1/21 to 12/31/21, there is 1 After 1/1/22, there are 2 => Raw data like this: Area forecast_date area 1 6/17/19 area 2 8/3/21 area 3 10/29/20 area 4 7/14/17 area 5 9/30/26 area 6 7/29/19 area 7 9/16/19 area 8 3/4/24 area 9 1/1/19
... View more