Question
Need help with data processing in CJA to create dashboards
Hi, I have a couple of questions I need help on:
- 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?
- 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!