Counting

[#1]

Dear All,

I would like to create a report for IBM Clear Quest software. Please check the excel file which has a raw data from IBM CQ database. What I want to do is to sort the action_timestamp field then count the "Kullanici_Testinde" value in the field of new_state. Would you please help me about it.

Best Regards,

[lironbaram]

hi

attach is a file

with what you described

hope it helps

[#3]

Hi,

Thanks for your prompt reply but I need more complicated solution. Let me clarify my request. I have replaced the date fields with timestamp in the excel file as you can see attached. What I want to do is to sort the id field first and timestamp field secondly. Then I would like to have the New_state value for the latest timestamp. Would you please send the sample file for this request. Thanks for your support.

Best Regards,

Asim Akin

[#4 · Accepted solution]

Hi Asim,

see the attached example (latest entry by customer solved in the script).

Hope it gives you a new idea.

Good luck!

Rainer