I have a card that looks at how many hours our operators spends on each customers account. The X axis has the account name/number and the y axis shows how many total hours we have spent over the time period (which for the card is year to date).
The columns that we are using from the data set include: account name/number, date the phone call with our rep happened, and the handle time of the phone call.
I am trying to figure out which account has seen the largest increase % of activity from month to month or week to week. The purpose behind this is to identify customers that are requiring extra attention before they become a problem.
Any thoughts on how to accomplish this?