solved This time, we want to assess the companies’ ability to

This time, we want to assess the companies’ ability to satisfy their performance obligations with respect to product sales by examining their sales returns.Retail Stores Data Link to the data or the companiesCreate a “combination chart” comparing sales and sales returns for each of both companies in each year from 2012 to 2021.Please answer the following questions.Which company exhibited a more favorable sales returns percentage in 2021, Retail A or Retail B? What percentage of that company’s customer purchases were returned?During the period 2015~2021, which company did show a higher growth in sales?During the period 2015~2021, did Retail A’s sales return percentage become (a) more favorable or (b) less favorable?During the period 2015~2021, did Retail B’s sales return percentage become (a) more favorable or (b) less favorable?Which company exhibited a more favorable sales returns percentage in 2012, Retail A or Retail B? What percent of that company’s customer purchases were returned?When you drag company to “Color” on the “Marks” card (at Tableau direction 5), what does happen?Explain what happens when you change to “Discrete data type” (at Tableau direction 2)To answer these questions, you may want to draw charts using Tableau as follows:The following is a part of the whole process. There is a missing part that you have to find out.Drag “Sales revenue” and “Less sales returns” under “Measures” to the Rows shelf. Change each to discrete.Create a calculated field by clicking the “Analysis” tab in the toolbar at the top of the screen and clicking “Create Calculated Field.” When a calculation window pops up, name the calculation “Net of returns.” In the Calculation Editor window, drag “Sales revenue” from the Rows shelf to the window, type a plus sign, then drag “Less sales returns” beside it. And then click OK. Drag the newly created “Net of returns” to the Rows shelf. Change to Discrete data type.Repeat the process one more time by creating a calculated field “Sales return %” that consists of typing a – sign and then dragging “Less sales returns” divided by “Sales revenue” from the Rows shelf to the calculation window. Click OK. Change to Discrete data type.Drag the “Sales returns %” to be right next to “Company” on the Rows shelf. Format to percentage.Drag company to “Color” on the “Marks” card.Click the arrow on “Sales return %” in the Rows shelf and select “sort.” Make the sort “descending,” or select descending from the Toolbar at the top.Change the title of the sheet to be “Right of Return-Variable Consideration” by right-clicking and selecting “Edit title.”Once complete, save the file as “TA02_Your initial.twbx.”Create a Word file and type your answer listed above. Name this file as “TA02_Your initial.” It should be formatted as MS word (.doc, .docx) or a text file. Any Apple file format is not acceptable. And submit it.