@ErikG I figured it out the hard way. It took time but it’s now showing in the desired way.
I made two separate calculated fields:
-
periodOverPeriodLastValue(distinct_count({Consumer ID}),{Consumer Created Date},DAY,0)
This was to calculate the number of returning customers days after install. -
maxOver(distinct_count({Consumer ID}),[{Consumer Created Date}])
This was to get the max value per row.
Then I made a third one where I divided 1 by 2, and changed the format to %.
