4 Replies Latest reply on Mar 2, 2020 8:15 AM by Ann Jackson

# Workout Wednesday 2020 Week 9: What is the 90 day reorder rate?

## Introduction  - Luke Stanke

I’m not going to hide it: this week will be hard. But this challenge is inspired by real events. In the four months I’ve helped solve various versions of this same problem: how do you do nest a table calculation inside of a level-of-detail calculation? You don’t. But you can nest table calculations–which is your challenge this week.

This week requires you to think through a challenge with 3 different levels of detail. First you must calculate if a customer re-orders within 90 days of the previous order. Next you need to figure out the percentage of reorders by customer. Finally you’ll need to figure out the overall reorder rate.

Difficulty: 10/10

## Requirements

For the requirements please go to Week 9: What is the 90 day reorder rate?

## Solution

Will be posted as an answer below.

• ###### 1. Re: Workout Wednesday 2020 Week 9: What is the 90 day reorder rate?

Hi Ann,

Here is my solution, slightly different calculations than the Luke's but same results. Loved the Table Calculation extravaganza!

Thanks,

Diego

• ###### 2. Re: Workout Wednesday 2020 Week 9: What is the 90 day reorder rate?

Hi friends,

Here is mine (for the sake of diversity),

hence no Table Calculations whatsoever.

Yours,

Yuri

• ###### 3. Re: Workout Wednesday 2020 Week 9: What is the 90 day reorder rate?

Just published my solution guide : table-calc-tastic!

• ###### 4. Re: Workout Wednesday 2020 Week 9: What is the 90 day reorder rate?

Solution video is now available: