7 Replies Latest reply: Mar 5, 2015 4:46 PM by Massimo Grossi RSS

    Max number of hits within a time range

      Hello all,

      I have almost 120K records (hits) within 6 months. I need to know what day had the max count of hits.

      I need this to be static (fixed value) during other calculations.

       

      The fields I have for this:

      ID_hits

      num(floor("FechaHora")) as DateFLOOR