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