Looks like I'll be "that" guy asking a ton of questions as I learn the basics of data manipulation.
Anyway, long story short, I have a list of phone numbers. Each phone number can have anywhere from 1 - 18000 corresponding records which have a date (this column basically says the date any time someone called the #).
Now I'm trying to get counts by different date ranges. I'd like to get a weekly count for the last 4 weeks, and then a monthly count for the past 6 months, followed by a everything that happened from 2014 to now.
Anyone have a suggestion on the easiest way to do this? I opened up a pivot table and it gave me a raw count of the totals for EVERY date, but I wasn't sure how to do this is on a larger scale with specific date ranges. (in the end i'll need about 10 columns for each # and there are about 150 numbers).