Skip to Content
Former Member
Aug 24, 2015 at 02:26 PM

First Value based on History Timestamp


Hello all,

I'm looking for some way how to create variable, which shows me only first value based on history timestamp. To be more exact... I have history fields in my report and some numeric values. Firstly, I've created variable running count - based on history timestamp, which give me # 1 to first value. Then I need to create new variable, which shows me value, where running count is 1 - for each ID (I have duplicate IDs in my report and therefore I want to see this #1 value in each record). I've used several options already, but unfortunately none of them was working 100% correctly. Don't you have an idea how could I solve my problem?

Btw. To use filter is not sufficient for me - I need this variable for further analysis.

Thanks in advance