Is there a way to do Excel BINOM.INV in Tableau Desktop?
The attached Tableau workbook contains a bar chart with error bars. This is done using the Binomial inverse calculation from Excel spreadsheet data.
I'm trying to find a method that could do the same calculation in Tableau.
Excel binomial inverse
Lower confidence interval =IFERROR((BINOM.INV([@Denominator],[@VaccinatedYTDRate],0.025))/[@Denominator],0)
Upper confidence interval =IFERROR((BINOM.INV([@Denominator],[@VaccinatedYTDRate],0.975))/[@Denominator],0)
PracticeKey | Category | ISOYear | ISOWeek | Denominator | VaccinatedYTD | VaccinatedYTDRate | Lower confidence interval | Upper confidence interval |
P140 | Adults aged 65+ | 2018 | 42 | 235 | 101 | 0.4298 | 0.365957447 | 0.493617021 |
P140 | Children aged 2-9 | 2018 | 42 | 879 | 7 | 0.008 | 0.002275313 | 0.014789534 |
Anybody knows a way to create a formula in Tableau to calculate Orange color figures(UCI/LCI)?
Become a Viz Whiz on the Forums! Support the Community and master Tableau.