First Value based on History Timestamp

[Former Member]

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

Juraj

[Former Member]

you can use rank function in webi.

you can do the ranking for timestamp & on basis of that you can fitler the records.

if you want more help then please provide the snapshot of report and objects being used.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

Yes, that is a solution, but if I rank my records and then use filter, although I'll have expected results, I can not work with this results in next steps. Therefore I'd like to create some variable for that.

Here is an example:

Incident ID	History Timestamp	Var_RunningCount	Var_OLD CBI	Expected Value to be shown
IM1111	17.10.2014 9:08	1	3	3
IM1111	17.10.2014 11:35	2	5	3
IM1111	19.10.2014 15:46	3	5	3
IM4444	1.6.2015 15:58	1	4	4

I've tried several options with IF, but none of them was working 100% correctly until now.

Thanks

Juraj

[Former Member]

What is your actual requirement can you please show me by giving example??

You can give ranking by using rank funcion in webi and then you can use nofilter function on top of rank so that even if you filter the report rank will give you correct output.

I hope you undestand my point.

Thanks,

Swapnil