Has anyone figured out a way to get an advanced sql report to have multiple columns instead of rows?
Right now I can search a node for component stats and get something like this:
Node1
Comp1 stat1
Comp2 stat2
Comp3 stat3
Node2
Comp1 stat1
Comp2 stat2
Comp3 stat3
However I want it to be like this:
Node Comp1 Comp2 Comp3
Node1 stat1 stat2 stat3
Node2 stat1 stat2 stat3
Or like this:
Comp Node1 Node2
Comp1 stat1 stat1
Comp2 stat2 stat2
Comp3 stat3 stat3
