Problem Statement: I have a query that outputs performance percentile statistics by operation methods. Example: |chart p50(duration), p75(duration) by method.
I want to be able to create a column chart so all the percentile results are stacked, meaning p50s stacked with P50s, P75s stacked with P75s). The problem is that my query returns the methods on the left as rows and the percentile as the column headings, so when chart it is stacking the values of the methods versus stacking the percentiles.
I tried using transpose, but that doesn't seem to work, because it gives me row 1, row2, etc and I cannot rename because the list of methods is dynamic. Thoughts?
... View more