Skip to main content
narayanan_s
narayanan_s
Contributor ⭐️⭐️⭐️⭐️⭐️
March 11, 2021
New Idea

Can we have rule formula to support Minimum, Maximum and Mean value of various fields on a row of record?

  • March 11, 2021
  • 9 replies
  • 112 views

We had a use case to understand what is the least metrics out of 10 different measures fields on a row of record and we couldn’t find a respective formula on rules under Number or Statistics ? 

Instead we developed alternative workaround like replacing every field value to multiples of 10s 100’s 1000’s and then summed up to say under which color category do they fall part (mapping the least to RED). If there was a Minimum or Maximum or Mean kind of formulas would have made it ease for these request.

      9 replies

      heather_hansen
      heather_hansen
      VIP ⭐️⭐️⭐️⭐️⭐️
      March 11, 2021

      @narayanan_s You should have those values on the field itself.  Does that solve what you are looking for?

       

       

        narayanan_s
        narayanan_sAuthor
        Contributor ⭐️⭐️⭐️⭐️⭐️
        March 11, 2021

        @narayanan_s You should have those values on the field itself.  Does that solve what you are looking for?

         

         

        That solves for column level on different set of records but when the ask turns within a single record set having 10 different number fields, we need to find the least out of 10 fields for one customer or relationship becomes tedious.

        Narayan
          narayanan_s
          narayanan_sAuthor
          Contributor ⭐️⭐️⭐️⭐️⭐️
          March 17, 2021

          hope we could move this as idea if there is no other options. Thanks!

          @sai_ram 

          Narayan
            rakesh
            Gainsight Employee ⭐️
            rakesh
            Lets put your data to work!
            March 25, 2021

            Hi @narayanan_s 

            Thats a good idea. We will consider this one as we evaluate our platforms formula capabilities holistically. 

             

            @All, do upvote it if you also faced this challenge. 

              narayanan_s
              narayanan_sAuthor
              Contributor ⭐️⭐️⭐️⭐️⭐️
              March 25, 2021

              Thanks @rakesh 

              upvote done from my end. 

              Narayan
                kevin.olayta
                kevin.olayta
                Contributor ⭐️⭐️⭐️
                March 25, 2021

                +100 this is a must specially for automating health scorecards. Thank you!

                  bradley
                  bradley
                  Expert ⭐️
                  March 25, 2021

                  While we’re at it can we get a SUMIF/SUMIFS function as well? IF statements?

                    jdoucette
                    Contributor ⭐️
                    March 31, 2021

                    +1

                      alizee
                      alizee
                      VIP ⭐️⭐️⭐️⭐️⭐️
                      March 2, 2022

                      Surprising it’s not been included in the product already, but +10000000000000000 on this. 

                      The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
                      Terms & ConditionsAccessibility statement