0 Replies Latest reply on Dec 4, 2018 2:26 AM by sameera.pathirannehelage.0

    Is there a way to do Excel BINOM.INV in Tableau Desktop?

    sameera.pathirannehelage.0

      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)

       

            

            

      PracticeKeyCategoryISOYearISOWeekDenominatorVaccinatedYTDVaccinatedYTDRateLower confidence intervalUpper confidence interval
      P140Adults aged 65+2018422351010.42980.3659574470.493617021
      P140Children aged 2-920184287970.0080.0022753130.014789534

       

      Anybody knows a way to create a formula in Tableau to calculate Orange color figures(UCI/LCI)?