time series statistical analysis

[eugenia]

I have a time series data regarding power consumed at a phone charging station with columns named: date, user id, and power consumed. I am trying to perform a statistical analysis to figure out the following:

1. how many people used the station? I have done this one by counting the number of unique user ids.
2. based on the unique ids, I want to identify the main contributors (people who's be using the station the most)
3. then I want to find the percentile of energy each of them consumed and the percentile of time which each of them used the station.

How can I do this using excel?

 

[arthurbr]

Have you tried a Pivot Table?

 

[eugenia]

Have you tried a Pivot Table?

Yes I have tried it. I was able to plot graphs from the pivot table. But was not able so sort the people who have used the station more

 

[arthurbr]

Yes I have tried it. I was able to plot graphs from the pivot table. But was not able so sort the people who have used the station more

Could you please explain what goes wrong? Pivot Tables can be sorted