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

    CRITBINOM in tableau?

    jonas.eegmadsen

      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?