Forum Discussion

kramaswamy's avatar
kramaswamy
Frequent Visitor
5 years ago
Solved

Measure to analyze current date vs record dates

Hi all,   Trying to figure out how to construct a measure that will return true or false based on whether the date being analyzed occurs after a record date and before another date on the same reco...
kramaswamy's avatar
kramaswamy
Frequent Visitor
5 years ago

Hi there Jay,

 

Not sure if this will help, but here's basically what I'm looking to do:

 

 

That third column ("Number of Requests Closed") should basically be getting the count of records for each time block that were open at that particular time. My records have two dates - the date they were opened and the date they were closed. So - if I were looking at 01 Oct 2020, I would want to see a count of records that, as of 01 Oct 2020, were opened and not yet closed.

 

If I had the following five records:

 

RequestedOnClosedOn
2020-10-13 0:002020-10-17 15:49
2020-08-30 0:002020-11-17 0:00
2020-03-21 0:002020-03-26 13:52
2020-03-23 0:002020-04-06 13:02
2020-03-28 0:002020-04-02 7:50

 

For 01 Oct 2020, I would expect to see only one record show up for pending. For 14 Oct 2020, on the other hand, I would expect to see two records show up for pending.

 

Does this make more sense?