5 Replies Latest reply: May 13, 2016 3:32 AM by Wei Chong Tan RSS

    Using percentile on gauge

    Wei Chong Tan

      Hi,

       

      I am using gauge currently and am trying to set the limits for the segment. Will I be able to set it as the 25th and 75th percentile on the gauge?

       

      Thank you!

        • Re: Using percentile on gauge
          Sangram Reddy

          Hi Wei,

           

          Are you looking to set the lower limit and the upper limit of the gauge to 25% and 75% respectively?

           

          If so, yes you can do it.Check these properties in the properties panel:

           

          Capture.PNG

           

          Thanks,

          Sangram

          • Re: Using percentile on gauge
            Stefan Wühl

            It would be easier to answer this question if you describe your current expression in the gauge chart and the underlying data model a bit more detailed.

             

            In general, you can use the fractile() function to calculate 25th / 75th percentile, like

             

            =Fractile( FIELD, 0.25)

             

            Since your chart expression is probably an aggregation also, I am not sure how you want to calculate the percentile here (based on what distribution).

              • Re: Using percentile on gauge
                Wei Chong Tan

                Hi all,

                 

                thanks for the reply.

                @Sangram. No I am not setting the upper and lower limit of the gauge. I wanted to set the upper and lower limit of the segment on the gauge. On the gauge chart, under "Appearance" > "Presentation", there is a checkbox for "use segments" I wanted to use that and set limit of the segment so I know if the value falls within the 25th o 75th percentile.

                 

                swuehl Please allow me to explain and hope I am clear in my explanation. I have column in my table called "speed" so the gauge chart is currently the avg(speed). I wanted the 25th and 75th percentile on the chart so that when I filter based on other dimensions such as "Providers" or "type", I will know if the avg(speed) after the filter lies within the segmented range. That is assuming that the filtering will apply to expression on the gauge chart and not the segments.

                 

                Thank you!