3 Replies Latest reply: Jul 8, 2011 3:28 AM by Kaushik Solanki RSS

    Max and Min Values in a day.

      Hello Guys,



      Have a look at the picture below. I would like to talk about the first three fields PageID, likes, record_date.


      What I need is, I want to calculate the maximum and minimum no of likes of a page made on particular date say like 06/09/2011.





      Can I use set analysis to acheive this..? Help me in this.


      Thanks in advance.

        • Max and Min Values in a day.
          Kaushik Solanki



              Just use the Max(Likes) and Min(Likes) if likes is a number,


              Use MinString(Likes) and MaxString(Likes) if its a string.


              So whenever you select a particular date, you will see the min and max for that day.


              If nothing is selected you will get the min and max for overall dates.



          Kaushik Solanki

            • Max and Min Values in a day.

              Hi kaushik,


                   I am using the max() and min(). and its resulting in overall maximum and minimum values. But I have no need to select any date.


                   I have the updated data from my client. Their requirement is, they want to display max and min no of likes in terms of yesterday, last week, last 4 week like that.


                   Help me to find out this.