I have a dataset fundamentally similar to the table below on the left. I need to summarize it to look like the table on the right, calculating the % of lines for each entry in the completed column for each shift for each time period. In a practical sense, a shift completed 2 red and 1 green during FM1, so the summary would need to find the % of red and green found by a shift during FM1... etc.
It is not feasible to make subsets for shift and time, since I will need to plot Green% vs Time by Shift. I've tried several summary table options but they all fail to calculate % of total for the completed category independently for Time and Shift, have yet to find an option that can treat them separately, has anyone ran into this issue before?
Accepted Solutions
You can also try tabulate:
you can turn it to datatable from red triangle menu:
With Summary table you might need to do some extra calculations either before or after creation of the Summary. Below is example doing them after:
Select either N Rows and either N(Green) or N(Red), right click on selected column and create new formula column:
Table after sorting, additional formulas and formatting:
You can also try tabulate:
you can turn it to datatable from red triangle menu:
With Summary table you might need to do some extra calculations either before or after creation of the Summary. Below is example doing them after:
Select either N Rows and either N(Green) or N(Red), right click on selected column and create new formula column:
Table after sorting, additional formulas and formatting: