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.

       

           Untitled.jpg

       

       

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

       

      Thanks in advance.

        • Max and Min Values in a day.
          Kaushik Solanki

          Hi,

           

              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.

           

          Regards,

          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.

               

                   Thanks.

               

              RB