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
Thank you in advance