I am trying to do a seemingly simple thing. I thought I could use a result-set approach but it did not work.
So, here is the task: group averages of numbers based on a category. An aggregate insight does that well. The problem is I want to put in a formula to calculate the difference between the averages.
Data:
| Category | Average A |
| Cat1 | 10 |
| Cat2 | 5 |
The result is a transposed set with a difference column:
| Metric | Cat1 | Cat2 | Difference |
| Average A | 10 | 5 | 5 |
Any and all suggestions are appreciated.
