Sum and Average for Facet Search

Submitted by will on Sat, 2009-08-15 03:48.

Brand New feature not seen anywhere else!

Normally when you do a facet search, you get how many hits for that facet. This is a great feature. But there is more!

Now wiht 2.1.6 beta, you can also get Sum and Average for a different field!

It's just like SQL:

  select count(*), sum(f2),avg(f2) 
  from t 
  group by f1

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Submitted by will on Mon, 2009-11-02 16:07.

Some users are requesting to sum() or avg() on several columns, rather than just a single one.

Why not! The feature to support more columns is added!

See here for more details:

http://wiki.dbsight.com/index.php?title=Configure_Search#How_to_do_sum.28.29_avg.28.29_for_narrowBy_Search.3F