aggr help

[#1]

Hi Experts,

I have attached my sample data and the required format.

can someone please help me to bring the required format in qlikview?

We have number of vehicles and the status count has to be for the period of one year regardless of vehicle number.

we can ignore the time calculation for the last status of a day but not the count(status).

Please help

[sunny_talwar · Accepted solution]

Look at the attached

[#3]

thank you so much sunny