Forum Discussion
Sorting table with multiple columns
Hi All,
I need to create a Line and Stacked chart for which multiple columns will be derived using the following conditions:
Table name: Survey
Steps/Logic:
calculate the no. of surveys
Group by Support Group
Get the total count of rows
Sort the values by total responded surveys
Select only Top 50% = hence total rows/2
Take the 50% rows
Sort it by highest % negative response
Now display top 5 values in the chart
Example data
| Group | # of survey | Negative response % |
| A | 148 | 0.68% |
| B | 67 | 1.49% |
| E | 19 | 5.26% |
| H | 38 | 2.63% |
| C | 37 | 2.70% |
| G | 705 | 0.99% |
| D | 17 | 5.88% |
| F | 32 | 3.13% |
| H | 5 | 20.00% |
| L | 6 | 16.67% |
| K | 11 | 9.09% |
| N | 24 | 8.33% |
| I | 20 | 10.00% |
| J | 109 | 4.59% |
| M | 130 | 1.54% |
Anonymous solution attached, look at table1 in attached, it has few columns and measures. you can play with it as per your need, didn't had much time to work on it thou but I guess you will get idea from it.
