1 Reply Latest reply on Nov 6, 2017 3:43 AM by Vasil Petkov

    Sort a 100% stacked bar by fail rate %

    Charles Kealy

      Greetings,

       

      In the attached dashboard I have a 100%

       

      I used the link below to get to this point, but I'm stuck in that the fail rates are bucketed but 100%, 50%, and 0% fails.  Within the 1-99% range everything falls into 50% and there's no sorting within it.  I used this formula.

       

      WINDOW_COUNT(if ATTR( [Approved (A)Disapproved (D)] ) = [Fail Rate] then count([App ID]) END)/window_count(count([App ID]))

       

      Sort a stacked bar chart bars based on values of a specific label

       

      Does anyone know how I can make the sort cleaner? Also is it possible to make the bars horizontal rather than verticle?

       

      Thanks!