Solr构面范围(按距离生成字段数)-字段的总和

我需要获取枢轴范围字段的总和。以下查询使用stats函数对 sumField 值求和。我试图求和frange子查询中的相同的字段,我不知道如何。

/select?defType=edismax&q=*:*&fq={!geofilt}&fl=totalResultsUsers,_dist_:geodist(),score&sort=geodist() desc&facet=true&rows=0&facet.limit=-1&facet.mincount=1&facet.sort=value&stats=true&distanceUnits=miles&wt=json&fq=dId:193&sfield=Coordinates&pt=40.243919,-74.753489&d=5&stats.field={!tag=t1}sumField&facet.pivot={!stats=t1}startDate&fq=startDate:[2019-12-01 TO *]&facet.query={!frange l=0 u=5}geodist()&facet.query={!frange l=5.001 u=10}geodist()

此查询产生以下结果:

  },"facet_counts":{
    "facet_queries":{
      "{!frange l=0 u=5}geodist()":27,"{!frange l=5.001 u=10}geodist()":0},"facet_pivot":{
      "startDate":[{
          "field":"startDate","value":"2019-12-01","count":27,"stats":{
            "stats_fields":{
              "users":{
                "min":1.0,"max":158.0,**"count":27,"missing":0,"sum":488.0,"sumOfSquares":40848.0,"mean":18.074074074074073,"stddev":35.09758475793535}}}}]}},"stats":{
    "stats_fields":{
      "users":{
        "min":1.0,"stddev":35.09758475793535}}}}

我要输入的行是:"{!frange l=0 u=5}geodist()":27应该是488.0,这是字段的总和,而27是字段的计数。

谢谢!

abxtoo 回答:Solr构面范围(按距离生成字段数)-字段的总和

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/2828630.html

大家都在问