1 Reply Latest reply on Apr 8, 2016 4:34 PM by diego.medrano

    How to get the Mode (Maximum) of a distribution

    Maxime BENOIT

      Hello there,

       

      I am currently working with two tables:

      - the first contains all the financial transactions of the company

      - the other contains the chargebacked ones

       

      I used Tableau to see the distribution of the number of chargebacks according to the time between the transaction and the chargeback.

       

      I want to identify this curve with a log-normal distribution. For this, I need to get the first "time to chargeback" that leads to a maximum (Mode), have you any ideas about this?

       

      Here is my calculated fields:

       

      TIME TO CHARGEBACK:

      if datediff('day',[Transaction Date],[Chargebackdate])>0 then datediff('day',[Transaction Date],[Chargebackdate]) end

       

      NUMBER OF CHARGEBACKS

      count([ID])

       

      Thank you in advance