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?
Im still searching a solution for this
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...