Median, mode, rank as formulae

We are trying to decommission quite a lot of our reports directly run from our database, and migrate them to end users through ThoughtSpot.

Currently these are a few things that would be really handy to help us with this process:

- Median

- Mode

- Rank

It would be wonderful if these could be available from the list of formulae.

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • I was told that median is expensive to use because it requires a scan of the entire dataset, but I'd love to see this aggregate in place. Mode would be helpful as well, though we don't use that as often (and can usually do it by just counting instances and getting the top 1 sorted by volume), but it would be really nice to have these as native.

    Reply Like
  • Hi May and Ryan,

    Thanks for the feedback. As Ryan mentioned, there are no native functions surfaced for Median, Mode or Rank. However, all of these functions are on our roadmap. We haven't assigned any delivery release for these functions yet. 

    Reply Like
  • Has there been any progress made for pulling in Median and mode?

    Reply Like
  • We have prioritized these functions. We hope to have them in the product soon.

    Reply Like
  • Siva Singaram Mike Henderson I'm still hoping to see these, so as soon as they have a scheduled release, we'll be watching for them. Thanks!

    Reply Like
Like6 Follow
  • 11 mths agoLast active
  • 5Replies
  • 983Views
  • 6 Following