Hi David, Thanks for the suggestion. Let me try to implement this as well. WIll get back to you soon.
Regards, Aditya. On Thu, Oct 22, 2020 at 11:03 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Oct 21, 2020 at 10:22 PM aditya desai <admad...@gmail.com> wrote: > >> As per application team, it is business requirement to show last 60 days >>> worth data. >>> >> > I didn't look deeply but it sounds like you are looking backwards into 60 > days worth of detail every single time you perform the query and computing > an aggregate directly from the detail. Stop doing that. By way of > example, at the end of every day compute the aggregates on the relevant > dimensions and save them. Then query the saved aggregates from previous > days and add them to the computed aggregate from the current day's detail. > > David J. > >
