2 Replies Latest reply on May 19, 2015 4:10 AM by jonas.eegmadsen

    CRITBINOM in tableau?


      Hi all


      I am interested in using the binominal CRITBINOM function known from Excel in tableau.


      I need it to calculate the minimum number of times a graph have to cross the median, in order to reject the possibility of a statistical significant development.


      In Excel the command is: CRITBINOM(n, p, alpha)


      n: is the number of valid observations, For that matter i use: WINDOW_SUM(IIF(ATTR(x)==ZN(LOOKUP(ATTR(x), -1)), 0, 1))

      p: is the probability of a given outcome of each test

      alpha: is the value of the criteria (in this case a standard value of 0,05)


      So what i need is a alternative way of calculating that in tableau


      Hope theres someone who can help?