I have an SQL statement that returns a table of data.
I can acheive grouping and summing in the SQL query without a problem.
However, I want to use the raw data in a dashboard and build several panels from this data set.
I can’t seem to achieve the same results with a transform. Tranform appears to do a group and then a sum, instead of summing by group.
However, the other operations in the transform, like count and “all values” show correctly.
Am I do something wrong, or does my understanding of “Total” not make sense?