I am working with a user behavior dataset that is cohorted by install date. I need to develop a dashboard that uses install date as the Y-axis and then a range of cohort metrics along the X-axis, such as:
Day 1, 7, 14, 30 revenue
Day 1, 7, 14, 30 retention
Although I am sure that this is super remedial, I'm having a difficult time making this table because I don't know how to index a cohort metric by period / day after install. I've tried using sets, which work for a single day after install but can't seem to do multiple days. I've also tried calculated fields (IF [Period] = 6 THEN [Retention Rate] END) but this isn't quite what I'm looking for either because the measure is still aggregated.