How to see weekly data without changing query by number of days

I am trying to view the Top 50 apps that consume APM weekly but my dashboard only has a monthly view. In order to view specific weeks I have to manually count how “many days ago” a specific date is just to run a query. Is there an easier and more efficient way to find this data? Sometimes when I run the query again for the same specific week, the data doesn’t always match up.

You can do like this:

...since '2020-09-01 00:00:00 EST' until '2020-10-01 00:00:00 EST' with TIMEZONE 'America/New_York' facet weekOf(timestamp) limit max

3 Likes

Thanks for sharing that query @6MM. :slight_smile: Did it work for you @allison_szeto?