Input

New Patient List

Solution Steps

  1. Finally the dataset which was not used earlier has been useful in solving this week’s problem set.
  2. First things first, we need to combine data from last week and current week using union statement.
  3. Before scaffolding, we will use the data from checkup frequency to create second visit, 3rd and 4th visits start date.
  4. We will re-use the flow from earlier week to update the patient level and daily level costs.

Output

--

--

Input

Solution Steps

  1. Delete unnecessary columns — Rank, Rider No., Times
  2. Convert Times into seconds by splitting the values
  3. Aggregate the data on Team name and count the no.of riders, calculate avg. gap in seconds
  4. Apply filters on count of riders to be atleast 7 and less than or equal to 6000 seconds on avg. gap to accommodate for 100 min avg. gap.

Output

--

--

Input

Input Format

Steps for Solution

  1. Use Union step to combine all inputs
  2. Create a Region field based on the table name
  3. Create LODs to calculate total sales of each stock under each region and overall sales (I am very bad at stocks related information, so reverse engineered what has to be done from the output format)
  4. Calculate how much each customer has purchased under each region as well as overall sales(Sales/Total Sales and Sales/Sales by Region)
  5. Remove the rows where atleast 1 of the % calculations is 1 , which indicates that this is the only purchase made.

Output

For some reason the flow kept issuing System Error which seems to be know issue with Union statements.

--

--