D
David Pagini
I would like to create a report that has a chart for each "grouped by"
element, and I'm thinking this may not be possible, so any help would be
greatly appreciated. Here is an (made up) example of the query results I'm
creating the report on.
Key1/Node1/Value1a
Key1/Node1/Value1b
Key1/Node2/Value1c
Key2/Node1/Value1d
Key2/Node2/Value1e
So I will be grouping by Key1, so this report will have two "repeated"
sections in it. In each section, I want to have a bar chart that has Node's
on the X axis, and the average of those nodes on the Y axis. Just to be as
clear as I can, the first "repeated" section of my report will have two bars
for Node1 and Node2, with Node1's height being (Value1a+Value1b)/2 and
Node2's height being Value1c. One possible thing I should mention is there
is an undefined number of Node's on each bar graph. Is this possible to
create a report which would operate in this way?
Thanks for any help you can provide, and if I can provide any more details,
please let me know and I'll get back as soon as possible...
-Dave
element, and I'm thinking this may not be possible, so any help would be
greatly appreciated. Here is an (made up) example of the query results I'm
creating the report on.
Key1/Node1/Value1a
Key1/Node1/Value1b
Key1/Node2/Value1c
Key2/Node1/Value1d
Key2/Node2/Value1e
So I will be grouping by Key1, so this report will have two "repeated"
sections in it. In each section, I want to have a bar chart that has Node's
on the X axis, and the average of those nodes on the Y axis. Just to be as
clear as I can, the first "repeated" section of my report will have two bars
for Node1 and Node2, with Node1's height being (Value1a+Value1b)/2 and
Node2's height being Value1c. One possible thing I should mention is there
is an undefined number of Node's on each bar graph. Is this possible to
create a report which would operate in this way?
Thanks for any help you can provide, and if I can provide any more details,
please let me know and I'll get back as soon as possible...
-Dave