I have a table produced displaying result from two queries, both grouped by two term columns (A, with a numerical value and B with two different string values, in my example below). Is there a way to further group/merge the result?
I would like to end up with a new table with two columns:
A (the numerical string value) and B (a calculated value based on dividing the two values in C).
For the sake of clarity (and for a chance that any of you understand me ), I’m giving you the example:
Basically I would like to produce the following table:
| A | B |
| 31463 | 1.16 |
| 31461 | 0.33 |
Is it possible or do I have to rethink/use another visualizer?