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

Actually - now that I think about it some more, it occurs to me that this information might not really even be possible, since it wouldn't really make any sense to roll that info up - IE, if in my previous example I wanted to see one record show up for 01 Oct 2020 and two for 14 Oct 2020, I would have to decide how the month of October should handle that info, and likewise, how it continues rolling up to higher levels.

 

Is that something I can program as part of the measure? I know that I can use ISINSCOPE to decide which stat is being presented - I suppose I'd have to use a different stat to display depending on what is being analysed? IE, if I were looking at the daily data, I'd see what I had described in my post, whereas if I were looking at monthly/quarterly/annually, I would, for example, take the day with the highest value within that month/quarter/year?