Can I nest aggregate functions?

Is it possible to nest aggregate functions e.g. moving_average (max(revenue),3,1,revenue_date)). I have tried on 4.2.2 and not parsing.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Ricardo,

     

    While Thoughtspot supports nesting of functions and even nesting of one formula field in another, it doesn't allow for nesting of aggregate functions like what you have mentioned.

    To do what you have asked for, you will have to create an aggregate worksheet that will get the max(revenue) at the granularity you want and have the moving average formula in a search that uses that aggregate worksheet.

    Like
Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 561Views
  • 2 Following