Calculates between datasets. Horizontal format
Hi to all.
I know that this topic has been raised several times already, but for an unintelligible reason, the option available here is not suitable for me.Either I do something wrong.
There are three datasets with the same column names, but different queries (+ compound columns)
In the end, you get something like this
| device1| device2 | device3 |blank
metrics_1 | metrics_2 | metrics_3 | grand total
grand total - must be the sum of metrics from three data sets (metrics_1 + metrics_2 + metrics_3)
How correctly or using best practices to perform calculations?