Unable to create a stacked graph based on child reports

Hi everybody,

We are trying set up a graph report but the results are not as expected.

Goals :

Create a report that graph (stacked graph) all IOPS (hosts resquest) of a group of host.

This report should have child graphs (one per host) that graph IOPS from all volume.  The last level of graph is to the have the IOPS of only the selected device (one graph per volume)

What we done

We created a parent report with a stacked graph. This parent only filter the metrics (name==’Requests’) and our selected hosts. The child ordering is « serialnb,name »

The first child report is a stacked graph, the name of the report is « « serialnb,name » . There is a expand property (simple device  + simple name). The child ordering is « serialnb, name, part ».

The last child report is « serialnb, name, part », with expand « simple : part ».

Our results

The last child report (IOPS for one volume) is ok.

The second level child report , stacked graphs of IOPS of all volume for a host is ok.

The main report is KO. The aggregation seems ok, but the curves (all IOPS for each hosts) are not accurate compared to low level reports. The trend is ok, but the range is wrong (40IOPS instead of around 500). I tried to change the « average » aggregation to sum. The graph is now better but only for real time values (1 day).

I think i made something wrong, do you have an idea. To reformulate, I want to create a master stacked graph which group each host total IOPS  (without using formula, just with child node).

Thanks for your help

Jeremy