Patrick DeKenipp You can accomplish this by creating an aggregated worksheet. Here are the steps:
1. Do a search for [user min timestamp] on the TS: BI Server worksheet.
2. Save this search as an aggregated worksheet. This option is under the Actions menu.
3. Do a search for [timestamp count user] on the aggregated worksheet you created. You can add [monthly sort by timestamp] to your search.
Steph Fisher You can try saving the search mentioned in step #3 as an aggregated worksheet and then doing a search on that for the number of new users along with a formula using cumulative sum to find the running total of existing users. For example: cumulative_sum( <number of new users>, <monthly timestamp>). You may need to change the default aggregation on your new users column to "Total".
Thanks Vanessa McAfee . Ideally I would like the new vs existing accounts to be metrics on a worksheet that I can pin answers to pinboards that can be filtered.
The issue I keep running into is doing a min(date) or group_min(date, account id) is when I filter, I don't see the original date the account is opened. I see the min date, per date filter. I'll work on putting together examples/better write up.