I am working on building a dashboard for a subscription product that offers a 30-day free trial. After the trial is over, customers have the option to pay for a full membership. I am trying to calculate a conversion rate based on today's sign-ups vs. the number of trials 30 days ago.
I was able to accomplish this pretty easily using a LOOKUP() formula, but that only works when the data is in a certain format. If my primary dimension is anything but an exact date, it will not work. I am looking for a way to define the number of trials that occurred 30 days ago without having to rely on LOOKUP(). Any ideas?
lookup is a position related function similar to offset in excel - i.e. move 1 call up - you need to read the actual date and work work with a datediff('day',startdate,date()) function BUT how to do that depends on the structure and the actual data - give it a try in your actual workbook and if you run into a problem post the workbook and your question here
If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote.
Also please help use better track your reply by including a mention to the volunteer who provided the answer – mine is @[Jim Dehner]
Thank you.
Jim
