Hi Tableau community~
I am trying to blend data based on date (MM-YYYY) for my fraud/non fraud analysis.
Basically when we get charegeback, we categorize them as fraud/non fraud and then analyze them by transaction month and partner
So, if a charge-back and reversal happen in one month, I have 1 line with 2 different dates, if happen in a different month, I would have 2 lines.
I would like to have a table (column : each month) and lines (CB amount and CB amount reversal by partner) but have been struggling to make this happen.
Could I please get some directions
Many many thanks
This is what I would like to see
Data Blending in Tableau happens when you have two separate data sources that can't be joined. Here you have only one excel file. So not sure what are you want to perform.