topic Summary Table For Multiple Variables in Discussions

Summary Table For Multiple Variables

TFranke — Sat, 10 Jun 2023 23:40:27 GMT

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?

Re: Summary Table For Multiple Variables

jthi — Sat, 13 Nov 2021 10:57:40 GMT

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: