Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...

New try

#New-try
Loading output library...
Loading output library...
Loading output library...
Loading output library...

Trying to visualize monthly trends

#Trying-to-visualize-monthly-trends
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...

Checking for daily trends

#Checking-for-daily-trends
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...

Trying Pivot table

#Trying-Pivot-table
Loading output library...

Grouping on status message for trends

#Grouping-on-status-message-for-trends
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...

No. of chargebacks as per country

#No.-of-chargebacks-as-per-country
Loading output library...

No. of chargebacks as per card ID

#No.-of-chargebacks-as-per-card-ID
Loading output library...

No. of chargebacks as per Card type

#No.-of-chargebacks-as-per-Card-type
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...
Loading output library...

Aggregate by Email IDs

#Aggregate-by-Email-IDs
Loading output library...
Loading output library...
Loading output library...
Loading output library...

Important Things to Note for final visualizations

#Important-Things-to-Note-for-final-visualizations
  • There is always a time difference between 'creationdate' and 'bookingdate' in case of 'Chargebacks'

  • There is no time difference when it is 'Settled' or 'Refused'

  • In 'Chargebacks', sometimes the 'issuercontrycode' is different from 'shoppercountrycode'

  • Aggregated data on mail_id, country_codes, card_type, shoppercode and