1 Reply Latest reply on Aug 26, 2016 2:23 PM by Patrick A Van Der Hyde

    working with cohorted data: selecting value of a measure based on a dimension

    Steve Palley

      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
      • etc

      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.

       

      any help would be greatly appreciated!