Need help with data processing in CJA to create dashboards

[aritrob]

Hi, I have a couple of questions I need help on:

1. I have a dimension with dimensions Card Issue Date, Card Activation Date, etc. These are in Date-Time format. I now need to create a couple of cohort tables that will show me how many cards were Activated within 5 days of being issued, 10 days of being issued, etc. I have tried converting the dimensions into metrics so I can attempt creating Calculated Metrics. Didn't work. Can anyone please guide me on how I can crack this?
2. I created a Connection with two datasets - Card Transactions & Product Holding. I will now have to create a dashboard listing customers with 1st/2nd/3rd card transactions done YTD, MTD. The Data Architect has given me this query to base my logic on.
   
   Join Product_Holding_Table
   On Card_Transaction_Table.ID1 = Product_Holding_Table.ID2
   Where Product_Holding_Table.CardActivationDate in Current Month;
   
   Long story short, I am not being able to figure out how to go about it. Would love to have your guidance on this!

Thanks a lot for helping me!

[kautuk_sahni]

@Tof_Jossic @yuhuisg @dwright @nnakirikanti @Anuhya-Y @Danny-Miller Curious to hear SMEs perspectives on this question. Do you all mind sharing your thoughts?